I grew up there many moons ago. As a kid it was pretty great, though I was always jealous of my cousins in bigger metros. As young adults, it might be a challenge socially. In small towns so much of the social activity is built around whatever school your kids go to from band concerts to sporting events, etc. I know similarly in bigger communities parents make friends with the parents of other kids, but there's a real attachment to the schools. You can build a white collar career there now much more easily than when I left in the 90s (Wells for one has really professionalised a lot the last couple decades), but would probably suggest staying in a larger metro for the career advancement and social benefits, and then if/when you decide kids are in your future, you can do worse than a smaller community. It's been said multiple times, but I wouldn't have had to chance to play/letter in multiple sports, band, and lots of other extra-curriculars at bigger schools. And those are the memories that stick out the most to me. Plus, my parents were friends with several of my teachers so they weren't afraid to put a foot in my a$$ if I got out of line

Good luck!