MY wife and I came to see waterfire for a weekend.
Nice hotel, downtown location. The area is typical downtown, you can tell that it used to be run down and now it is on its way up... very close to everything.
One thing I think you should now - there is a church right across the street and the church bells are right in your room so if you want to sleep in on Sunday - forget about it!
Otherwise - nice clean hotel with decent prices.
Oh, prepare extra $25 for parking.