It was a terrible inconvenience just with the charging aspect--I don't think there are any other hotels in Charleston with even level 2 charging.
There is (always check plugshare.com). Generally it's a bit riskier (as I almost found out on my last trip through) as you never know whether the charging stations are even working, or in use, or ICEd, but I do prefer to use L2/destination chargers at hotels (usually it's free and is good for getting you up to 100%) rather than dealing with Supercharging at a nearby hotel, although in the case of the Charleston Supercharger/Courtyard, I suppose it wouldn't be a hassle at all to go move the car once it's done charging.
We stayed at the Fairfield Inn in South Charleston. They have 2 charging stations there, although when I was there only one was operational, and when I arrived there was another Model 3 using it (darn!) but by the time we got up to our room and I looked out the window, I noticed the other Tesla owner was unplugging, so I was able to get a charge after all.
I just checked plugshare and as of Sep 30th one of the stations was still down, which is very disappointing since I told two front-desk staff about it and they told me it had been called in. As a backup, there is a charging station at a library a block away that I would have used. Part of the problem is that it's the city that installed the charging station (the hotel probably "allowed" them), and so the hotel doesn't have a sense of ownership over the charging station (even though it probably attracts EV owners to their property).
Another option, not right in Charleston, is the Hampton Inn in Hurricane, WV. They have a 3 Tesla destination chargers and a J1772.
At hotels, I would always recommend talking to someone prior to arrival and let them know you are intending to charge your car when you arrive and have them verify (if possible) that it is working. Sometimes they will even be able to block the station for you so it doesn't get ICEd. Also check plugshare reviews to get the latest reviews and news on the charging stations.
And yes, make sure you ask for guaranteed late arrival at hotels. Just giving your credit card number does not guarantee that, although it's odd they would ask for it if not to guarantee your room.