Sydney's works fine. London's too, not the special one the regular tube one. Also Tokyo Narita and Schipol. What they've all got in common is that they're well connected to a good public transport system.
The SFO airport BART line serves the suburbs too and it counts just fine. Airport connections come in a bunch of different varieties. I agree that Bangkok's is definitely one that's faced challenges though!