Let me do this one first.
Really? So you see the Dakotas as an icy wasteland? I’m sure it’s not as lovely as your upstate NY, but there are lots of people living there and doing just fine. Perhaps you need to get out more. 
I think, perhaps, that you have some misconceptions about real estate investments. I don’t claim to be much of an expert myself, but I did live through Austin’s real estate boom, bust, and resurgence, and invested in some property through it all. I knew at the time that I bought each property that I might not make any money in the short term, but I had confidence in the Austin market, and that, given time, my investments would pay off, and they did, even the one I made in 1984 just months before the bottom fell out. Today that property is worth over twice what I paid for it, it’s paid off and through it all I’ve been getting monthly rental payments. So 23 years later I still own the property I bought in 1984 and I intend to own it 20 years from now.
That’s the way most real estate investment works. Normally you don’t just buy some property and let it sit there, but you lease it out or work it somehow to cover the payments, taxes, etc. In most cases. you’ll eventually sell it, but that timing will vary greatly on a person by person basis.
Of course there are those investors who buy real estate with no plans for it other than to flip it at the most opportune time. I saw plenty of those, also.
Then there are people like my brother who buy land simply because they want to own land. They just like to go out on their property and enjoy it. The economics are secondary, and their only plan for it is to pass it down to their children and grandchildren.
I can see any of these three types of investors, if the circumstances were right, investing in land that they expect might benefit from global warming whether that be in northern climes or elsewhere.
Based on my own experience and my own observations your broad statement that “(real estate) investment strategies are gauged in terms of years, not decades, to recover initial investments” is simply not true except for the "flippers"and even they could come out ahead with this “global warming speculation”. After all you wouldn’t necessarily need to wait until the full effect of global warming kicked in for a property to appreciate. If the theory is correct (and granted it may not be) that northern states and Canada will become more habitable and productive in the foreseeable future, then the mere expectation that that will happen might be enough to trigger speculation and if you start seeing measurable changes that are attributable to global warming such as slightly longer growing seasons, that could certainly do it.
Ultimately it may just be that global warming presents us with too many unknowns for speculators right now.