dave submitted an MSNBC article about the Nixon transcripts from a while back. There are some great quotes there:

"Can we tell them 'no?' When I talked to the president, he was loaded."
—Henry Kissinger to his aide in October 1973 when British Prime Minister Edward Heath's office tried to set up a telephone call with Nixon about the Arab-Israeli war

This exchange between White House chief of staff Alexander Haig and Kissinger reveals Nixon jokingly threatening to drop a nuclear bomb on Congress as it moves to impeach him in March 1974:
Haig: "I was told to get the football."
Kissinger: "What do you mean?"
Haig: "His black nuclear bag ... He is going to drop it on the Hill."

"Look, people get drunk ... People chase girls. And the point is, it's a hell of a lot better for them to get drunk than to take drugs. It's better to chase girls than boys."
—Nixon on a graphic account of Amb. Arthur Watson's groping stewardesses while drunk on a March 1972 flight to Washington

There's plenty more, so follow the link.