There all just digital transfer mediums and can all sound very good or not so good. AES/EBU and S/PDIF are very simaler even though S/PDIF used to be thought of as pro-sumer digital, because it carried SCMS code, but that line's a little blurred now. AES/EBU is carried on a 110 ohm cable with XLR type connectors, though this shouldn't be confussed with a mic cable and they're not interchangable. S/PDIF transports througha 75 ohm video type coax cable usually on RCA type connectors, some times BNC.
Lightpipe is ADAT optical digital format and carries 8 channels of 16 to 24 bit, 44.1 to 48KHz audio at a time, AES/EBU and S/PDIF only two at a time but can handle higher resolution, 16 to 24 bit and at least 96KHz (I'm not sure off the top of my head what the max is).
I have no fav and I use whatever is appropriate for whatever the equipment I'm using at the time has. My multi tracks are ADAT, my DAT and mini disc are S/PDIF and I have some mic pre's that have AES/EBU.