I can't assume your age or knowledge of the economics of the state over time. But this suggests an extremely limited memory over time. All of this activity, everything you mention as reasons for excitement for Detroit (oddly ignoring the rest of the state, which makes up a far larger chunk) ignores the historic cycle of economics in Detroit and the automotive sector. It's going to take one healthy recession to spur layoffs en masse and send money scrambling out of state again. Nevermind the asinine city and state taxes you'll incur living within the city limits, the high cost of living. While they may appear reasonable or even desirable compared to Cali, you're buying into a disadvantage by default.

You need but look at Miami to find a polar opposite of advantage, opportunity, and excitement with longevity.