Off the top of my head, following are airports that have train service, but the journeys are 30+ minutes:
-PVG (both the Maglev and Airport Link are fast, but getting to their stations takes just as long as getting to the airport in most cases)
-PDX (sure, you can find a hotel at Gateway or further out, but what's the point?)
-PEK and PKX
-DEN
-EWR
-JFK
-SFO
-OAK
-NRT