A "great" hotel experience I had recently was when I happened to casually mention to someone in the hotel restaurant that it was my wedding anniversary tomorrow. When I came back from touring through the city the next day, the reception staff gave my wife flowers and wished us a happy anniversary. Then when we entered our room, we found a small cake with anniversary wishes.
That kind of attention to detail is what I would classify as a truly "great" experience.
