I'm just north of Pittsburgh PA. Probably look at destinations near water like Charleston, SC, Chesapeake Bay, Put in Bay, Mackinac Island. Places like that. Neither of us drink other than an occasional glass of wine and we aren't partiers so bar/party environments wouldn't be likely. Although wife wants to go to New Orleans sometime...lol.
I searched for a few clubs near me and the one closest to me seems their website is down but it did list a contact name and email. There was one near Cleveland that listed rates. Too far from here but at least I got a ballpark number and the club thing might not be a bad idea. If that all pans out with the airport closest to me then I may start taking the next step and actually get up in one for a discovery ride.
One issue we need to consider is me and my wife are about 500lbs combined so a 152/2 seater might be an issue. Looks like we would be cutting it close in a 152. 172 looks like roughly 100lbs more payload? Fine for renting/club use but at some point we will want to take one of our kids and their spouses so looking at closer to 900lbs minimum. Even so, I wouldn't want to be right at max with just us 2. Hopefully we can knock about 100lbs off of that by then but I have been saying that for awhile...lol. Step-son bought me an XL shirt for X-Mas. I wear 2X so my goal now is to fit in that shirt comfortably by next summer. Gonna hang that right in the front of my closet so I see it every day...lol
The WWII museum in New Orleans is fantastic. We spent a day there. Mardi Gras World is great stop as well. They make the floats there. There are many great restaurants there too; although I don't know what damage COVID has done to them. There are plenty of things to do in New Orleans without spending a dollar on Bourbon Street.
One of the big benefits of flying is expanding the range of "where can we go for the weekend?" Traveling in a straight line at 115 to 180 knots makes a much bigger circle than driving at 70 mph and having to get through Friday after-work traffic.
Getting your weight down is good for a lot more than flying. That's a good goal to have.
When you are ready, start with the discovery flight. If that's good, start with lessons. Enjoy flying and see where it takes you.