I stole this from the Maxxis site. Said better, faster than I could:
Something like a 120 tpi tire would be ideal for a road bike. 700x20c tires and 100 psi for instance. I lived for those things back in the day. Literally. Take a hard corner on a 100 psi tire and you really want it to be...