Organizing MP3s and Other File Collections?

Anonymous Coward asks: "After trying to merge several sets of media files that I've had laying around across several PC's (and looking at the short-comings of my own Perl script), I began looking at some commercial products and was overwhelmed. Does Slashdot have advice for organizing MP3 collections and what software works well for them?"