There’s been a lot of similar posts in r/Connecticut. I’d recommend a search there to get advice on local communities and their strengths/weaknesses.

tldr…check out West Hartford, Glastonbury, South Windsor and surrounding towns for “have it all” communities. If their prices are out of budget, check out Rocky Hill, Vernon, and some others. These other towns are more my speed in terms of having a more relaxed vibe.