I live in New York State. I first visited Titusville about 12 years ago. I was staying at a friend's condo in New Smyrna Beach for a week. A space shuttle launched and I saw it from the beach in New Smyrna. I later decided to take a drive south and see what's happening around the Space Center. I found the Haulover Canal manatee deck (with manatees that day!), Playalinda (beach) and the Merrit Island preserve. I loved them all. For the next 10 years I vacationed there in April or May for a week. I stayed in most of the hotels over those years. The Hampton Inn was the only decent place, but it was pricey for me. I have also stayed in the Ramada, Best Western, Super 8 and Days Inn -- some once or twice -- but mostly I stayed in the Best Western. All except the Hampton Inn were bad or horrible rat holes. The bad reviews seem to be honest. I guess the Brevard County Health Department doesn't "do" hotels.
A year ago I bought a condo in Titusville during the Florida Real Estate bust, so now I have a decent place to stay when in town.
I really like Titusville. I love the nature preserves and the great natural beach. I don't really care for drinking and carousing all night. I think the Dixie Crossroads restaurant is a decent place to get local seafood. The new bakery downtown is excellent. This past February I bought some fresh shrimp at the downtown farmers' market and whole wheat pasta from the bakery and made the best shrimp and pasta I ever ate anywhere.
I am in the process of learning more about the local artist scene. My sister is interested in the downtown antique stores. It seems to me that Titusville has been trying to go more upscale in the past couple of years. I hope it's successful. It's got a lot of potential. Now that I am a property owner, I want the housing to get really expensive!
One thing I never understood is the buying of tickets to see a shuttle launch. There are loads of places along US1 to watch for free. Twice I have watched from the Max Brewer causeway (just east of the bridge, near downtown Titusville, which goes to Playalinda.) From some of the other places along US1 you can also see the actual launch pad towers. Just look north of the huge Vehicle Assembly Building. The pads are easy to see during night launches because of all the searchlights on the launch pad. You can see the launch towers in the daytime, too. If I was coming for a launch, I would stay in the Hampton Inn or Fairfiled Inn, drive down to US1 and find a grass strip along the Indian River.
I hope this is helpful. Titusville is a nice place and it's getting better.