Mansion Virreyes is GREAT! I know previous reviews haven't been great, but they have done some remodeling or something, because we loved every minute of staying there.
Normally, breakfast is included in your room rate, but the cooks were on summer vacation the week we stayed. The hotel graciously gave us a discount.
The courtyard is beautiful, and great for enjoying a few drinks in when you need that mid-day siesta. And if you want a view of the streets of San Miguel, just walk up to the rooftop area, complete with seat and lounge chairs.
Also, it should be mentioned that this place has a FANTASTIC location. The Jardin is only 1 block down; there is a bar 10 feet down the street; many shops are located within 1-4 blocks; a bank is right across the street...I could keep going.
While the beds were a bit hard, I think it's important to remember that you shouldn't be visiting San Miguel for the hotel room - get out and enjoy the town, and drink enough so that when you come home at night the bed feels softer!
Also, the rooms vary in size and accomodations. Some people we knew staying with us had 2 beds and 2 baths; other had one of each. Somebody even had a suite with a mini-fridge. If you favor any of these things, be sure to ask when you book your room.
Anyway, I've said enough! Stay here! It's a great place!
This review is the subjective opinion of a TripAdvisor member and not of TripAdvisor LLC