If the FL facility didn't exist and scientists and engineers of today had to choose the most acceptable location, they'd still choose the same spot where things sit right now.
The weather is only one of a number of factors. Russians and Chinese launch from inland locations because they don't care if a stray rocket falls on a city, and they don't have to worry about getting sued. They don't allow suing the government. They don't even allow complaining about the government. NASA has to launch over open ocean. U.S. citizenry wouldn't even begin to consider allowing rockets to take off with trajectories passing over populated territory. Earth rotates west to east, so to take advantage of existing inertia, launches must go that direction. This limits it to the east coast. The closer you are to to the equator, the greater the centrifugal speed, so this means going as far south as possible. Going to the FL keys or some island farther south would expose the facility to even worse weather, poorer security against terrorism, and make the costs of supporting infrastructure impossibly high.
This is STILL rocket science. Millions of things have to go perfectly right for these things not to blow up on the pad. More launches are delayed for technical problems of other types than from weather. Scrubbed launches would be a fact of life in any location on earth.
I agree, Kennedy Launch facility does not have the world's most ideal launch weather. When ALL factors are considered, however, it rates out as better than any other potential site. It was people who endlessly complained about scrubbed launches that caused all the pressure to launch (and ignore other potential problems) when NASA shouldn't have that led to the two disasters that have already happened. Rocket science is something you can't be impatient about. That's just part of how it is.
The Air Force is working on an alternative for smaller satelites. They have been testing putting small rockets in the fuselage of a C-17, (when this is ready they'll fly out over the ocean and find clear weather somewhere at the equator), and dropping the whole solid fuel rocket out the back payload door at about 30,000 ft. The 65,000 lb. rocket will right itself, ignite, and be able to put a 1000 lb. satelite into orbit. Maybe some new system will be able to do similar things for manned rockets in the future, but with the current type vehicles, there is no location with better sum total qualities than Canaveral.
To read more about the C-17, and great articles about military aircraft in general, take a look at
Air-Attack.com - News & Facts on Military Aviation and Space Projects absolutely great site!