She has her time back and travels constantly to visit her family.

., travel nurses) especially in the Bay Area, who could give me some advice?

We have everything you need to manage ready in a can: photography, advertising, application, leases, rules and regulations, smoke detector notices and all other forms you need and background check (we do this a lot).

The idea of owning and managing vacation homes that provide memorable stays for travelers excites me.

Here's a quick summary:Manchester: STR demand could come from business travelers, especially near Hartford.Canton: Lower demand unless near outdoor recreation areas.Southington: Strong option with year-round tourists (skiing, Lake Compounce).Bristol: Good potential with ESPN and tourist attractions.Berlin: May have less demand unless near major highways.Focus on properties near attractions or business centers to keep occupancy high.

He wanted me to travel with him and buy some of these deals. 

You could invest out of state, which would open up different risks and costs (trusting your PM, additional travel costs to see your property(s) periodically, likely less personal market knowledge).  

I have a 4-unit property up in Cape Coral, FL that is currently wrapping up construction. I've been approached by a couple of sober living facilities and would perhaps prefer an independent living provider if possible...

Hard wired smoke detectors, egress windows or stairs to name a few.

I just don't want to continuously travel here.