You really can't see much from the coast when it is landing. They don't let visitors near the landing strip anymore, so from the distance you would be from it it really just looks like an airplane. My friends parents live out there about 10 miles from the Cape and we went out to the beach to see it come in and completely missed it cause we were expecting it to be a little more grand.
As for the sonic booms, it depends on what direction they are coming in. You can not always hear it in Orlando. If they are coming in across the Gulf of Mexico and across the state you will hear it, but if they are coming in the other way you will not, if they are coming up the east coast (from Miami) it is hit or miss, sometimes you hear it sometimes you won't. As others have mentioned though, it is loud, if you are in a building you will hear the boom and the windows/walls will shake, but if you are outside you might not hear anything at all.
Anyway, I would not go out to the Cape for a landing, it is nowhere near as grand as a launch and you do run the risk of missing it all together. I would plan to be inside about 5-10 minutes to landing (remember it is going about 800 miles per hour when it comes in so the sonic booms will happen fairly close to the landing time).