Mozilla - Also try OmniWeb. 4.1 just came out of beta, and it's too bad. Mozilla seemed in need of some PPC optimizations when I ran it.

MP3 tagging - Not sure, haven't done much of this on OS X yet

Cannon - Hmm, no major problems here yet with my Powershot S30, though I haven't done a raw import yet. Most of the time I just let iPhoto do the import, and I run Image Capture when I have movies to download.

Sleep - Do you have a timeout set in Energy Saver? I don't have any specific suggestions here, just wondering if the WOL is canceling the timeout somehow.

Virtual Window Manager - I haven't looked around yet, I really have never gotten used to the idea yet.

David, do you know of a way to flip the default so that when I click a program, it hides the other one, and if I hold option, it keeps both up?