Stayed for a weekend at David's place and it was just what we needed. My two college-age kids joined me for a weekend of sightseeing. Plenty of room for the three of us to spread out; the kitchen is available if you want to cook or just make coffee. And David has thoughtfully provided maps and guides for the area (plus a small umbrella for you to borrow if it's raining.)
We got around using a combination of Lyft and Uber and the subway and, though the neighborhood is clearly being gentrified, we always felt safe. We walked to the nearby Columbia Heights metro station, to the Target store in Columbia Heights and to the corner grocery for a Coke.
Bonus: We were totally charmed by a neighborhood cat, who greeted us with meows when we came home on a rainy evening!