> Sadly, I think this is only easy to accomplish in mid-sized densely-populated cities (<= 250000 inhabitants), unless there's a lot of planning and investments done.
You are right about the "easy" part, but it can definitely be done. In fact that's what Tokyo feels like, and it's the largest city/metro area in the world, with 38 million residents.