Not sure it would fit, because item #1 is mostly contradicted but regardless here's my review of Brevard County, FL [outside Cape Canaveral - specifically Merritt Island]
-Climate: Sun, check. Arid/Semi-Arid, no humidity is technically high, HOWEVER outdoors due to an almost constant 4-7 mph breeze from the Gulf Stream often doesn't feel that hot outdoors (A/C however indoors is a must in most cases). ZERO winters (literally no snow recorded for the county that I see). Supposedly the average annual high is only 92F (this is supposed to be the hottest week of the year this past week, and our max was 92F one day)
-Affordability: Value is all over the place, there's literally multimillion dollar mansions to properties under $150k without leaving Merritt Island, even gorgeous canalfront properties like what I'm currently renting regularly sell around $300k. If you're willing to go off the island you can get enormous places in Palm Bay for example for under $200k with a pool. If you like being near water at all however, it's the most affordable community I've ever seen without making some large sacrifices.
-Culture and Cuisine: Well on Culture, we've got Ron Jon and Cocoa Beach as one aspect of culture - all the space program stuff here - and of course more mainstream "culture" aplenty if you hike 60-90 min away to Orlando. Cuisine is relatively hit or miss in the county itself, but again, Orlando and outlying areas to Orlando (60-90 min away) and you literally have anything you can dream of, for obvious reasons.
-Convenience: Traffic - Very light, goes for the entire county. Public transportation/walkability - not so great great for an area with this low of a population density though. (I'd compare it MD for both - while still rural) Crowded, not at all. Crime is below the national average, I think the lowest crime county in the entire state. Shopping is pretty amazing for such a small area, thanks to Cocoa Beach being next door we've got an amazing amount of shopping all within around 3 miles for quite a low population. (Besides Best Buy at least, only thing that involves a hike - that's about a 40 min trip to get to)
-Local Points of Interest:60-90 min from all the Orlando attractions (I don't need to go into it). Port Canaveral (scheduled to be the biggest cruise port in the US by 2020). Lots of springs/natural hiking trails (esp bird watching ones) nearby. Literally ON water to the point where I'd estimate 20-30% of the local population own a boat of some size. Literally can fish from quite a few homes - depending on where on the island even have manatees that will sun in the canal. [Ours is one such during the winter]
ZERO mountains (its Florida after all).
-Nearby Points of Interest: Already covered most of the 60-90 range since Orlando is so ubiquitous. Keys are around a 4 hr drive or so and seem like they'd be awesome (not visited yet).
And to just reinforce an aspect you seem to have heavily implied - due to the combination of a number of factors:
1) Affordability
2) Wonderful area with plentiful opportunities for entertainment of various sorts
3) ZERO state income tax
4) A very lenient homestead exemption on property tax
5) A generally tech/engineer heavy population due to NASA, the Air Force, and aeronautics industry being so large here.
There is a really booming population of "nerd culture" here that has really been pretty amazing - there's other groups like retirees and such too - but tons of work at home tech types have flocked here because of so many things that appeal to nerd culture.
[And while I do have a bias towards Merritt Island specifically, North Melbourne/Viera/PSJ is quite nice as well - slightly more affordable even I think, further from water though [like 20 min away] but would also have you within 35-40 min of Orlando, etc]
A possible negative to the county, and ESPECIALLY to Merritt Island however, is if you like a diverse mix of racial groups - Merritt Island itself is incredibly white, something like 97-98% with the county being in the upper 80% range.