Forget the overhyped duds. These famous destinations are actually prettier than the pictures you've seen of them.