I know there are hotels with a higher level of personal attention and service, such as the Reegent mentioned above, but unquestionably the most memorable hotel experience I have had was the Princeville Hotel on Kauai.
It was just the combination of friendly and helpful staff, the quality and amenities of the rooms and public facilities, and the spectacular setting that I have not encountered anywhere else.