I can't say enough good things about Kansas City. We came here after college, as a temporary city until we figured out where we wanted to live, and haven't left in 31 years. It has everything a cosmopolitan city has, with down home family friendly people. Its a big small town and a small big town. The Chiefs, Royals, Country Club Plaza, street cars, music and arts, and museums. Lots to do. Great cost of living.
The suburbs in Overland Park are where most families go. Look in the Blue Valley School District and Shawnee Mission School district on the Kansas side to live for family neighborhoods (Missouri side to invest). Lots of private schools in midtown if you like older houses with character.
On the investment side, plenty of opportunities in whatever property you are looking for.
The City is experiencing quite a bit of growth. Lots of development commercial and residential. It is also insulated from the ups and down of the coasts.
OK, I'm a bit biased, but it really is a great city for everything you are looking for.
And I waited until the very end to mention the excellent BBQ.
Aloha.