Sorry to hear about your experience. A feeling of helplessness.
Kudos for Agoda for stepping up, albeit post-facto.
My only problem w/ Agoda was a month ago...I purchased a junior suite. About 2 weeks later I was informed that the room type was not available. Disappointing, but not as bad as what you experienced.