Check out the very simple and effective interactive transit map of New York City, you can also see London (via Cartography Blog)
It's a great example of a useful mashup/data display (since he entered the data, and isn't really pulling it live from another source, it's not really a 'mashup' - but then again, what is a 'mashup'?) The data Greg used is available from his FAQ.