Thats the hotel I'm thinking of. We stayed there on our last trip down. It's on the southern side of the river front close to the pirates house. Nice place for the price. If ya have the money and you can find an open spot, check out the numerous bed and breakfast's. We try to stay in a different one every time we go but they stay booked and cost a bit more. It really depends on who is going with you, for us, just me and the wife-B&B, others with us-we stay in that hampton inn.
Food- breakfast and lunch are good on riverstreet, different places. Dinner and upscale- the pirates house is good, my favorite place is the old pink house, it's more upscale, try the lamb chops and the lobster bisque. Of course there is the lady and sons, decent.
Tours- I like the walking ghost tours after dark. there is a tour that does it but we always go on our own to the cemetarys, colonial park is in the district but the good one is on the outskirts and you'll have to drive, it's down by the river on the south side of town.
The one thing you must take home with you- pralines from river street sweets.