I think it looks great on cityscapes like the one you've just posted, but generally speaking I don't like it. I've seen a few chaps on Flickr who HDR on everything they do - don't really see the point, personally.
What I do like though is tilt shift images. There's basically 2 ways of doing them - buy a specialist lens for a tonne of money or cheat it in Photoshop (there are a load of tutorials online).
The effect is has is to make aerial photography of real places look like they're miniature models. Here's an example.
Haven't tried it myself like, but I'd love to give it a whirl.