Jana at StrongMocha has this excellent post on making your own sound effects.
Of course not being a sound guy I have found the lack of audio plugs ins to be an issue with sound fx in editing programs, but possibly I do need a small suite of audio plugs ins to improve my ability to work on sounds effects and make them better.