I've never seen an extended-stay hotel in a neighborhood that I would visit for leisure. They're usually in pretty ugly, utilitarian spots - off a cloverleaf or behind a strip mall - serving business travelers.
There's a Hyatt House I pass by sometimes right next to the Shibuya crossing; though I'm guessing that one definitely does not have the price advantage.