Yeah, the subway maps are really, really cool. The only thing is that a lot of the cities also have train systems that aren't represented, so some of them look smaller than they might otherwise.
The bottom of the subway page gives a link to this other site that has a similar map of North America, and includes more trains and bus rapid transit systems.