DC is a large city, I wouldn't think any consensus would be meaningful. A lot of people are crochety, adoring, frustrated, and contented with the city. Also in my experience no city is going to be a good match for all people.

I really like the city, but that opinion doesn't generate a ton of discussion. People that enjoy the city are largely out enjoying the city, not on this sub