New England has been a great place to fly in my opinion. I remember taking off from Morrisville-Stowe one crisp winter day and after climbing to altitude over the Lamoille Valley, being able to see Mount Washington in New Hampshire over 60 miles away.
New York City was another cool place to fly if you didn't mind having to dodge airspace and talking to the controller to get what you want. Although now I probably wouldn't have done what I've done earlier in my younger foolish days. Trying to stay out of the New York Class B south of Long Island and trying to get into the Hudson River, New York Approach kept me below 500ft along the shore and handed me off to Kennedy Tower. It was kind of interesting being overflown by the heavies out of Kennedy, as well as flying up the East River, doing a steep turn to avoid LaGuardia, and then going up the Hudson River after circling the Statue of Liberty a few times.
I just recently had an opportunity to fly in Hawaii. The scenery is spectacular, especially along the north shores of Molokai and Maui, but your crosswind technique better be pretty good. As it's pretty turbulent near the surface. Flying in Hawaii is a bit different, GA
support is almost non-existent, so getting fuel can be a bit challenging sometimes.
San Diego and Southern California has been my local flying area as of late. Unfortunately in Southern California, although the flying is pretty good, the visibility is absolutely horrible, with haze and smog reducing visibility down to 8-10 miles most of the time. After you climb out, the air is a sickly shade of yellow and brown. The air is relatively smooth along the coast. Although inland it gets turbulent. I really like the marine layer, it made for some easy IFR time. Flying up the coastline is pretty scenic and you get to watch the rush hour traffic on I-5 moving up and down the coast.
I do have to say I'd probably kill to have a job as a pilot with Flight International or Phoenix Air, the guys which do target towing for the Navy over the Pacific Ocean off Southern California. I think I'd like to buzz the Navy ships and jam the crap out of them for once instead of being the sitting duck waiting the "shoot" them down. Those guys come in at 100/150ft at 350-400kts and the CIWS Phalanx 20mm guns just go nuts trying to track them.
Bonus animus sit, ab experientia. Quod salvatum fuerit de malis usu venit judicium.