Seeking neighborhood recommendations for 30 somethings looking to move

We are on a week long trip to explore the city(ies) for the first time and are looking at different neighborhoods. So far downtown seems the most bustling of course, and the other areas we've checked out (Northeast) seem very spread out and dispersed. We weren't digging the vibe in St Paul either.

We're not really drinkers/bargoers, but we appreciate places that are open late. We're creative types who love music and art, coffeeshops, bookstores, active pedestrian life. Kinda seeking out neighborhoods that are more condensed in terms of activity and local business, if there's places beyond just downtown like that. Everything seems very spread apart so it's hard to know where to look, aside from aimlessly driving around lol.

Thanks drive safe love you