Soulseek is pretty much awesome. Especially if you're looking for non-mainstream stuff. Limewire is great too. Those are the 2 I use.

But I also use BitTorrent for album downloads, concert bootlegs, and whatever else I can't find on the normal P2P.