Agree with most comments above. Went to Santa Cruz once, never had the urge to go back since. Same with Bay Area in general. Though I do want to check out Coe.
Used to go to Sedona a lot. But now most trails have been made official and are signed, the hikers have found them. We never used to see many people on the trail, now most trails are overrun with gaping morons, both on foot and on two wheels. I'll still stop in for a day or two but it's no where near as good as it used to be. My favorite trails on the backside of Hangover were all shut down a few years ago.
I've never seen a photo or vid of Bend riding that made me think "I've got to go ride there" or that made the riding look interesting or challenging. I don't get why everyone thinks its so great.
Lots of other places that are hyped have decent riding and I'll do it, but not as its own trip. Places like Park City, Fruita, Crested Butte, Monarch Crest fall into that category. Interestingly I went back to some of those within the last couple years and thought the riding was better than I'd remembered. 401 in CB was a good example - didn't remember the descent being as much fun before. Lots of short rides, but I guess that's what most people like. Holy hell that place is busy though.
More locally, Mammoth has always disappointed me. Not as hyped, but Big Bear and Northstar too. But I am jaded living in BC and getting to ride Whistler for years ruined most other resorts for me. Cannell Plunge is another ride everyone in Socal is in love with that I think is completely overrated. There is much better riding even from that same trailhead that pretty much no one rides.
Moab and St George/Hurricane have so many different rides and such great scenery I find it hard to want to go back. And there is always new stuff being built. I won't spend a week at Moab again but a few days are always worth it, busy or not. There is still lots of lesser known but fun riding to do there.
Sedona glory days:
https://i958.photobucket.com/albums/...2/IMG_3161.jpg
http://i958.photobucket.com/albums/a...2/IMG_3176.jpg