Austin[/end]
... with that said, there's plenty of water-front here but it's freshwater lakes/rivers not marine/coastal as-per Steve's preference (as well as mine).
Easily can get a mega-McMansion in the 'burbs, but gotta drop some coin to get something neat in the notable areas. EVERYONE is moving to Austin, and generally from high-cost areas (with their equity to drop on the desirable local real estate).
For those with means & resources, a T-&-C (Town & Country) approach is getting more & more popular: a high-rise modern condo/apt in town, a more substantial personal home in/around the lakes, hills, ranches.
Downtown's skyline looks like Dubai with all the cranes (minus the indentured slave-labor). Unrecognizable year-to-year. And there are new housing developments (starter, McMansion, custom) in all directions, sprawling everywhere.
A Florida coast sounds like the OP's calling, in terms of wants/needs and preferences/requirements. The Space-coast (Flagler, Daytona, Ormond, Coco) is close to Orlando. The South Florida coast has a flavor for all (Delray, Deer, Pompano, W. Palm, Ft. Laud, N Miami, SoBe). The Gulf Coast areas (Clearwater, Palm Harbor, Naples) are adjacent to the Tampa-StPete metro. Being 45mins to 1hr away from one of those 3 major Florida metros can land a solid spot on the sand for some surf & year-round sun, relatively affordably...