I am currently trying to create various sound effects for the Truck Game.
It turns out its quite hard.
I have resorted to finding some sound effect libraries but I have also found a few very useful tools
http://thirdcog.eu/apps/cfxr
cfxr can generate random sounds that you can modify.
I have been finishing them off by using audacity.
http://audacity.sourceforge.net
Two great tools.