ADAT "lightpipe" is an amazing cable format in that it carries 8 tracks of digital audio on each super-thin fiberoptic cable. Saves a lot of hassle and cable routing. And it beats the fuck out of Tascam's competing clunky TDIF standard.
SPDIF is basically stereo digital RCA. Useful, it has its applications, but not nearly as impressive. Some older gear requires you to pair up SPDIF with coaxial word clock cables, which is annoying as fuck and no fun, as it doesn't always work properly in more complex setups. Most modern gear can transmit/recieve clock over the SPDIF cables themselves, thankfully.