We've found a really nice RV Park called Manatee Hammock which is right across the water from Kennedy Space Center. We're literally a 5 minute drive from the space center! The entrance tickets were a little expensive at $41 each but we decided to go anyway. The tickets do allow you to visit the space center two days and they really have a lot to see and do! We did a tour of the center, from finding out where they assemble the shuttles to how they move the rocket to the launch pad. They have an IMAX theater where we watched a movie about the Hubble telescope and they have multiple museum areas and learning centers.
We toured mock ups of the shuttles. We especially loved comparing the astronaut's life to our RV living. The astronaut toilet and showers are way bigger than your average RV bathroom! However the astronauts had WAY more storage space; the floors, walls, and ceiling of the shuttle are all drawers and cabinets! RV'ers also have much nicer bedrooms than astronauts.
I guess the moral of the story is: If you want to do something cool like traveling in an RV or exploring space, you must be willing to accept that your accommodations will not necessarily be spacious! But it's worth the sacrifice!