It must depend on the place doing the inspection. I've had one jack up one side of the car to look underneath and another that put my boss' car on the lift to check the tightness of the front end, which they ended up failing him for.

Some places definitely do as little as possible but there are some that really try hard to fail you. They are on camera now so there is less they can get away with.