I like Audacity very much. I have used it to create small sound effects for use in widgets and as system sounds, but also to create new and complex sound effects for the local community theater (my thunderstorms are always a big hit!). It is extensible, too, so there are many handy plug-ins available to help you get things done. Audacity is one of my favorite open source apps.