Sherwood Forest apples-to-apples is clearly more desirable than University District [[and Green Acres) , though University District is a bit more walkable/urban, given its an older, slightly closer-in neighborhood with fewer lots.

I think, if you're betting on a large-scale Detroit revival, University District would have the most upside, as it's the closest to downtown and anything approaching urbanity, but all will be good bets if the NW Side revives [[and obviously not-so-hot bets if it doesn't).