We very much enjoyed our stay at the Marriott Courtyard. It has a good restaurant with decent staff; a great breakfast, although expensive for Mexican standards.
Our room was great. The bathroom was large, the room well laid out, very clean, and the bed was comfortable. We stayed in room 717 and sacrificed a view for quietness.
Right off of Montejo, the main drag in Merida, this hotel is well located. Self-parking with an elevator that takes you right to the parking/your floor; very convenient. Very decent gym, as well.
I've stayed at 4-5 Marriott Courtyards in the last year, primarily in Florida, and this is by far the nicest one. It's more at a Sheraton or even Hilton level. Staff is attentive but not hovering.
Overall, a great place to stay. And visit La Pigua, a moderately-priced seafood joint within walking distance of the hotel. Also try Spasso, an Italian restaurant at the Hyatt a block away. Pricey for Mexico, but not for the quality of food and considerign it's in a hotel.