Check out this article to see some migration patterns of where people are moving.

I know that you can get better cash on cash returns out of state, but Denver has its own benefits too: diverse economy, great beer, net migration is positive with no signs of slowing down, awesome weather, etc. 

I'm trying to nail down the area, and I'm leaning towards Orlando or the "Space Coast" near the Melbourne area.The challenge, of course, is that Florida's prices are steadily increasing with the rapid in-migration, which makes BRRRR investing their more of a challenge.Curious what you all think of BRRRR investing in those two areas, or where in Florida might be better for that particular strategy?

Then that starts to go against the investment thesis of pundits who are predicting the death of the office and mass migrations out of large cities for the same reason.

I'm interested in upstate New York because I've seen it pop up and mentioned on various BP products, but census data shows migration moving away instead of to that area.Anyway, any tips, tricks, advice, and recommendations would be much appreciated!

If the system won’t allow this in the beginning you will have to migrate the data to a more robust system later

From what I've read about the area, it looks like there's been a net migration of young professionals out of the region, to the point where a good chunk of residents there are a bit older in age.

As a passive investor (AKA limited partner) in apartment syndications, I do a fair amount of macro-level research on the economy, markets, tenant/landlord laws, taxes and migration trends.

Are tertiary markets going to see an increase in value and demand due to demographical migrations?

The positive net migration supersedes the other areas you mentioned.