There's lots of great hotels in Boston, but everyone's definition is different.
Do you have a specific area you want to stay in? A price range? Services (spa, great dining, a pool, etc)? You mentioned the Waterfront area, but only the Battery Wharf hotel is near the water.
Let us know what you need and we can better answer this question.