PhotoGuy, what exactly were you thinking of when you asked us this question? What are you hoping to accomplish? If you like trying out stuff, you can first try Canon's free DPP software to process your photos. For some people, that's all they need and it's free. The quality of photos processed using DPP is very comparable and sometimes better than what you can get with Adobe software so don't feel like you need to get photoshop something. The reason people use something other than DPP are for other features that DPP doesn't offer. If you're looking at the Adobe software you can download trials to see what you like.
I think it's important to figure out what you want. I was in your position not too long ago and I decided I wanted something easy to get started with and to use but also give me room to grow. I ended up with Lightroom and later bought photoshop. That's the combination many professionals use and I highly recommend that combo if you have a need for photoshop. I did try DPP but really didn't give it a serious go as Lightroom was affordable and I was convinced that Lightroom was a better long-term solution for me with it's superior ability to organize my photos. You'll hear professionals say that they use Lightroom most of the time (some even say 90% of the time) when working with their photos and that's because it's really that powerful and preferable to use. Lightroom to me is indispensable. I dismissed PS Elements pretty early on because I feel it's a program that tries to fill in the gap between Lightroom and Photoshop CS5/6 and really didn't. But if you feel like you will never need the features that a full version of photoshop offers, and you're just looking for a software to touch up a few photos at a time and not a whole lot of photos then Elements might be all you need or a good compliment to Lightroom.
So it comes down to your needs. Think of CS6 as two programs. One part is Camera Raw, the program you use to process your photos. The other part is the part that most people associate photoshop with (removing stuff, sliming down bodies etc.). What it lacks is an easy way to organize/manage your photos. Elements is essentially a scaled down version of CS6 with a photo organizer. Lightroom has the exact same engine as Camera Raw and is seen as a compliment to photoshop because of its superior ability to manage photos. With that in mind, figure out what you want out of the program. Do you need the full functionality of CS6? If not then do you need what Elements has over Lightroom? Can you buy both?