When we cruised out of Charleston we stayed the night before at the Holiday Inn Riverview. It was great! Just ask for a room with a river or city view and you will really enjoy it. We could see the ship from our room when we got up Saturday.
The hotel has a nice restaurant/lounge on the top floor with walls of windows and great views.
They allowed us to leave our vehicle for free while we cruised and shuttled us to the pier. Dropped us off right at the door! When we returned after the cruise, I called them as I was leaving the ship. Walked across the street from the dock and they picked us up within 15 minutes. We were in our car and on the road home within 30 minutes of stepping onto land.
I would definately stay here again when sailing out of Charleston, SC.