I have fond memories of using the subway/trains in Tokyo. Ditto for Seoul (which I'd rank even better than Tokyo's), Hong Kong, Singapore.

I dread using the subway in NYC and nowadays try to avoid using it as much as possible (mostly via biking).