I've never used a CD audio cable and music cd's play just fine with media player. That's true with 98SE, ME and XP. I haven't noticed them spinning at max speed either, but I've never paid any attention to it. System specs are in sig.
So,
If you use the cable: you get analog music, don't tie up the IDE channel, and don't spin your drive at max rpm's
If you don't use the cable: you get digital music, is much more resource intensive (IDE and PCI), drive spins like mad
That sound about right? It may be better to use the cable and get analog sound to save resources. I'm sure I have one laying around somewhere.............