We've all been there. The stairs, the lack of parking, no green room to store your gear, dodging patrons while you loadout, getting someone to watch the car while you load in. Unfortunately, horrible load-ins are just part of the job description. All you can do is try to make your gear more portable (sorry drummers).
Some venues, though, are MUCH worse than others. These venues are not necessarily shit venues, but they will definitely give you a solid workout.