Window units are the best bang for the buck. Don't worry about expensive ones, $100 goes a LONG way to cooling one bedroom. And it's cheaper than doing the whole house.
We have a big in wall unit in our apartment that can do the whole living space, but we hardly ever run it. We just run the bedroom one, set to like 70-75f, just to take the humidity out and chill it down a bit. A nice place to go cool down if you get hot while doing things around the house. We don't run it when we're not home, because even the cheapest Menards special can cool the room down in minutes, and it's cheaper to not run it when we don't need it.
Beware of the units with the hose... You're paying more, and trading the convenience of not lugging a big unit into the window (small ones really aren't that bad), for the inconvenience of having to dump the water (unless you pay more for one that can pump it out the window).
But by far the worst thing about the hose units, if they only have one exhaust hose, and no return hose? They are less efficient, because they create negative pressure in your house that sucks hot air in through every crack.
For more information see here.
I'm not a crane-ologist, but I've seen the seat there before, and it can make sense from a design and ease of operation perspective.
Here are some examples: