I think this depends on what you want out of a tourist attraction. For me it's usually been food, golf and decent weather.
Thus, I'd take Reno over LV as the golf is a billion times better and you can actually get to other places, like Tahoe and Truckee from there.
I'd probably take San Diego over SF at this point as SD has stepped up in food areas I'm enjoying more these days. Although I also have a fondness for Sonoma/Napa.
Sedona is beautiful and all, but Phoenix wipes it off the map food-wise.
San Antonio is a great 2-3 day stay. Not sure if it would hold my interest longer than that. I got to know Dallas fairly well due to my former employer's relationship with Sabre. I've probably been to a lot of places only the locals really know, and it's really not as awful as portrayed here.
I can't imagine anywhere in LA being as enjoyable as NO.
In FL, I've enjoyed Little Havana and Miami Beach, but I like the vibe of the west coast better - spent a decent amount of time in Bradenton/Sarasota and Metro Tampa/St Pete. If I were to ever move to FL, it would be there.
I don't really have an opinion on VA. I lived in Alexandria, and while there was much to do, I can't see it being a compelling place to visit for fun. I'd probably head to Virginia Beach, go swimming with dolphins and slum at shrimp shacks and BBQ huts.
Crazy as it may sound, in MD, I'd pick Baltimore. Annapolis is picturesque but has no soul IMO. Baltimore actually has some decent neighborhoods (Hampden being one I particularly enjoy) and the area from Inner Harbor to Camden Yards can be fun.
OH... no opinion. Not crazy about any of the cities. Same for Indiana.
Milwaukee is underrated. And while I'd take Minneapolis over Duluth, Dultuh actually surprised me as far as being much more interesting than I'd thought - I had no expectations yet thoroughly enjoyed my stay there.
I worked in Montclair, NJ off and on a couple years ago. I could live there easily. Strong community and a lot going on for a town of its size.
Probably because I know the area so well due to previous hiking trips, I'll go with North Conway'Lincoln in NH. I've spent more time in K-Port in ME than anywhere else due to a friend having a beach compound there which was particularly enjoyable. Love Portland, but there's not much more there than a day trip. But SE Maine as a general area is certainly worth a trip.
In VT, I've enjoyed the Bennington area quite a bit, and will admit my opinion on Burlington is partly shaped from having a job interview up there in February. Not a chance in hell I'd ever live there.
I'd probably take Stamford over NH in CT. Then again, I grew up there. SW Fairfield Cty is its own state as far as attitude goes.
I live in Pittsburgh, so I'm biased. If someone cast a vote for Philly but hasn't been here in the past 15 years, you should book a trip. And if we weren't so close to WV, we'd never set foot in the place, but downtown Weirton is starting to get a vibe. It might become the Brooklyn of the Appalachians.
Most other states I've only been in one city, so can't really compare those to anything else.