I have a home in Hartford and I'm a big advocate of the city. I think it's great you are considering living here. If you are a young professional you may like Bigelow Commons in Enfield. Normally I don't direct people away from the city but if you are working in Enfield it's worth taking a look. Enfield is also about halfway between Springfield and Hartford so you have some options for weekends.