Great location but not nearly worth the money!
Years ago I was in San Antonio on business and stayed at La Mansion del Rio. The room was very clean and comfortable.
My wife and I (and 15-month old little girl) were finally able to get away for the weekend and decided to spend it in San Antonio. When I called La Mansion del Rio's reservation desk, they indicated that the hotel was almost full, so I booked an Ambassador Riverview room at $409/night. 
We arrived around 8:30 PM Friday, March 23, 2012. The valet service and front desk staff were very professional and welcoming, but the room was extremely disappointing.
The room smelled like it previously was a smoking room and also had a musty smell. The carpet throughout the room was excessively worn and had large stains near the balcony door. The bathroom was small and the fixtures are extremely outdated.
More importantly, the bathroom wasn't clean. There was hair in the tub, the baseboards, particularly behind the bathroom door, were extremely dirty, there was toothpaste on the mirror frame, and the toilet didn't flush very well. The bathroom towels were clean, but were old and worn thin, and the mattress was old and lumpy.
Around 11:30 PM the same night we checked in, my wife and I decided that we didn't want to stay in a dirty room, particularly with a baby, so I informed the front desk that we would be checking out the next morning. To their credit, I wasn't charged any type of cancellation fee, but the front desk worker didn't even inquire about our stay and why were were leaving a day early.
I have stayed in significantly better quality rooms for much less that $409/night. Based on the quality of the room, it should not have cost more than $100/night.
When we checked out Saturday morning, I complained and was given a $100 credit, which was appreciated.
Friday night we ate dinner at Las Canarias restaurant. The service and the food were very good. Saturday morning we ate the breakfast buffet at Mokara. The service and food were also very good.