I don't see any particular reason that Inwood will be more desirable in 2040 than Brooklyn Heights. Being physically on the island of Manhattan just isn't that big a deal. What matters in the long run seems to be commuting time and to a lesser extent zoning and projects.
Looking at this heat map: http://project.wnyc.org/transit-time/#40.75805,-73.98571,12,...
I'd be bullish on Sunnyside / western Woodside.