ISO a new town! We are moving from the Midwest to New York in a few months

A little about us: We are a mid-20’s gay trans couple moving to New York for my husband’s job. He rides motorcycles and I kayak/hike. Currently we live in a little city with a population of 120,000 but it is truly a small town; It’s a college town as well. Other than that it’s rural for 2hrs in every direction. We both grew up in the rural outskirts so we prefer that. I currently work in a music venue but am looking to get out of nightlife since my husband works 9-5.  I’ve written up a list of what I’m looking for in a new place to live:

Requirements:
Has an Aldi and a Walmart
Has a gay bar
Has some sort of music scene, small venues/outdoor venues/diy venues are all good
45 min drive max to a body of water that I can kayak and swim in (I kayak 4-5 days of the week)
Has a good population in mid 20’s/early 30’s

Wish List:
Arthouse / independent movie theater
Local artists collective- somewhere that offers classes or has mixers where I can make some friends
Big farmers market
Cool tattoo shop- somewhere that has women/queer/poc artists mainly and not just old dudes doing exclusively American traditional

I would love some input on where we might be comfortable. We were both born and raised here and finding somewhere new is pretty intimidating. We’ve visited Syracuse but it’s way too big for us, so we’re hoping for something liberal but still kind of rural. College towns are good, as long as there are non-student housing options. I’ve included the general area that we could choose.

Where should I live?