The link above may help more than me. Since I live here I can't say much about redemptions. But my impression is that hotel rates in the city are fairly high.
With respect to Metro, "functional" is not the word most frequent users would probably choose. Especially on weekends when track work makes the system virtually unusable. Frankly I would choose a hotel in the city that would allow you to walk to most places you want to go.