The Lobby Lounge and MOBar in the Mandarin Oriental both have pretty decent views. The views aren't like Top of the Rock or the ESB and drinks aren't cheap, but both are beautiful spaces and you could probably wander around a bit and check out the view and leave without having to buy anything.
If you really want a view, though, the Top of the Rock is the way to go. It's worth the admission ticket.