The startup that is working on the app you want, covering every city with any public transportation, is going to release sometime in 2036. Coming soon!
Living in a city with crappy public transportation, I really don't care about that—I'd just prefer a mapping application with a better user experience.