These may not help you, but maybe they'll help someone...
1. I find that some wasted cache space (or something) is sometimes recovered by simply rebooting. (And then there may be stuff showing up in the trash you can look over and then get rid off.)
2. In the case of a Photoshop crash leaving big scratch files behind, simpley launching and quitting Pshop helps.
3. Certain apps (I'm thinking UT2004 with certain mods installed) make an ever growing log file. This too can be resolved by launching and quitting.
4. For logs, cache files, etc., try searching in your Library for files over 50 MB and see what turns up. Maybe something you can throw out. (But to be safest, try just launching and quitting the associated app first, and see if the file shrinks. Then if that fails, drag the files to trash and make sure the app still launches OK before you Empty.)
5. This great app, Yasu, will run basic maintenance tasks for you--ones your Mac does anyway on a schedule, but you can have them done now. It can also empty all your browser and download caches.
http://www.versiontracker.com/dyn/moreinfo/macosx/21674
I've been told that you non-browser caches are useful and should NOT be deleted except for troubleshooting. Therefore I check only THESE 5 boxes in Yasu:
* All 3 cron scripts (scheduled system maintenance) in the top box
* Browser and download cashes in the middle box
Plus if you wish it can restart for you when done.
(Note that Yasu can also Repair Permissions. That's usually useless--in current versions of OS X--and also takes a while to perform. But it's also pretty harmless if you're obsessive and it helps you sleep

This according to MacWorld:
http://www.macworld.com/2006/08/secrets/repairpermissions/index.php?pf=1 )
If you want to perform a really thorough system maintenance do this:
1. Restart with Shift held down (until the spinning wheel). This restarts in Safe Mode, but more importantly it runs Disk Verify & Repair on your HD before booting. (Other ways to do this involve using your OS X DVD or the command line.)
2. To get out of Safe Mode (which is limited) you reboot again. So I let Yasu do that for me, after running the above chores (plus Repair Permissions for good measure). Yasu will run in Safe Mode.