As I’m not very familiar with the US market, I’m doing my own due diligence.Any thoughts or advice on these markets or others I should consider as well as any other considerations? 

Short answer is as little as possible.The long answer is it depends on the deal.Typically you end up in a subject 2 situation when the current owner has little or no equity in the property, the current advantage of subject 2 properties is that most mortgages are below current market rates.Keep in mind when acquiring a property subject 2, in most instances you are not notifying the current lender of the change in ownership, and most if not all mortgages have a due on sale clause, which is the lender's decision if they want to enforce it or not.I personally like the idea its a great way to get investment properties with low rate loans, that with most likely appreciate in the coming years.

Several people in this thread have been in my market. 

Do you and your wife stay in one market or do you move around often?

I’m an investor with capital and was presented a potential deal to purchase an off market 83 unit self storage facility.  

Do you really think it's too late for Nashville or is it just a tougher market? 

My initial plan was to do a house hack in whatever market I find appealing.

August 2024 payroll numbers continue to show a resilient job market, despite revisions expected to push the data higher, following a trend seen in previous years.

Is Connecticut just a bad market?

I was watching the market for quite some time.