This struck me -- Mello, are you interested in software geared toward actual, one-shot sound effects? Or are you interested just in making your own music?
If you just want something good for sound effects, the thing you'll want to look into first is Audacity. It is a very easy to use, yet powerful audio editor that allows you to take any sound effect (from a file, or recorded yourself) and clean it up, alter it, apply filters/effects, and on and on. Price tag is $0.
And, although it is certainly possible to engineer a complete song from scratch using Audacity... I would not recommend it. There are better tools available to handle that specific job.
If you want software that isn't too audio-geek (which can be just as bad as tech-geekery to the uninitiated), you have a few option. One that springs to mind is LMMS (the 'L' stands for "Linux" -- but don't let that scare you, there is a Windows version, too). Not the most feature-rific music tool, but comes with plenty of its own synthesizers out of the box (and includes a SoundFont player in case you want to play something more akin to traditional music genres), and it easy to use. LMMS is free.
Fruity Loops is also an option. It costs a decent chunk of change, but in comparison to other commercial audio software, it is a modest price (and it is tiered, so you can pay less and not get features you don't want).
If you want a more "full-force" and powerful audio package, I highly recommend REAPER (free to try, with a "consumer" license costing only $60). It has a definite learning curve, but is probably one of the most straightforward (and customizable) pro-audio packages out there (even in comparison to apps that cost several hundred bucks). The caveat is that it does not come with samples you can use to play your music (you have to supply your own). If you have none, you could look into something such as Acoustica Mixcraft which is somewhat similar, but can be purchased in packages with samples bundled with the software. Mixcraft will cost you a little more than REAPER, but I think their "top-ticket" package is still around $150.