What is typical really varies by location, too. Around here, NOTHING is signed until the house has been inspected and that contingency is cleared. When we sold our house in TX, they had standard forms to use so attorney involvement was not required or customary. IMO the most important thing you can do is get an attorney who is familiar with the customs of the area in which you are looking to buy to guide you through the process.
You most certainly should be there for inspection and generally after the inspection there is a chance to renegotiate based on what you have found. You should not view the inspection as a chance to nickel and dime the seller and give them a laundry list of things to fix so that you have a perfect home. I think many buyers make the mistake of thinking that every little thing that shows up on the inspection needs to be addressed by the sellers. What you should use it for is to make sure that your offer is fair based on the condition of the house... did you make an offer based on the understanding that the roof is in great shape when in reality it needs to be replaced very soon? Are there signs of water damage? Mold? Termites? Basically you should be looking for deal breakers or things that affect the value of the house.
On the other hand, a decent inspector WILL give you a laundry list of things that should be addressed. You should view this as an opportunity to have a pro come look at the house and tell you what things you should take care of and how to avoid later maintenence issues (for example, our inspector pointed out where a missing downspout was causing water to hit the side of the house rather than run away from it. It's a simple fix and no big deal and certainly for the $30 part it was not going to be a deal breaker... we'd rather make the repair ourselves so we know what we are getting). On the other hand, we have a slate roof and if there had been significant damage to it, it would have created problems for how much we were offering on the house since repairs can be costly.
The best thing you can do for yourself is to have professional people who know what they are doing looking out for your interests.