There are a lot of families in the service industry who have been here since before the real estate boom who have a little singlewide in the woods on some of those dirt roads north of 98.
As for other areas, if you don't have to be right on the beach, Bluewater Bay really does have a strong Columbia, MD influence- variety of different types of housing, many recreation opportunities (which are for the most part a la carte, so you aren't paying for tennis courts you won't use) and designed to be walkable/bikeable. You can find some smaller SFHs for less than $250K, and some very nice larger options for less than $400k. In terms of covenants and HOAs, it's a mixed bag- some older neighborhoods have no HOAs, others have very strict covenants and HOA presences.
Demographic tends to be rocket scientists (Defense Department weapons folks), Air Force officers, and other professionals. Sometimes I feel kind of dumb because, unlike my neighbors, I only have one masters degree.