If you think about it, the only people that benefit from people en masse becoming infatuated with a certain neighborhood (or likewise shunning certain neighborhoods) are Realtors, who make $ based on turnover of property in certain areas, and Realtors are all pure Evil. I actually gave up driving my car after I moved down here; only 5 months thus far, and I estimate I've saved a lot -- far more than I would have spent otherwise -- in transportation costs, time, and even energy.
I guess I just don't understand your point. I've never met a genuinely creative person who ever gets bored. I guess I don't really think of "getting bored" being resultant from a function of place.
There's nothing like having crazy people yell at you while you walk home, unless it's being panhandled 20 times during a 15 minute walk. Or maybe all the "urban camping" that goes on. Nothing like the smell down by the bus station early in the morning... :)
I got a great workout everyday walking back and forth to work! At least, until I wussed out and started riding the cable cars. I'd go back anytime. Great location.