I still use CS2. It does everything I need. I used the free trial version of CS5 for a month a few years back, and I've tried the Lightroom free trial too, but neither of them offered anything that made it worth the switch for me personally. I've also got Elements 12, and I'll sometimes use that version of Camera Raw for a shot that needs lots of shadow recovery.
Note for Elements users: there's a very handy utility called Elements+ that unlocks a lot of the full Photoshop features that are usually inaccessible in Elements. The free trial version gives you access to things like curves and color balance that aren't usually there, and the paid version unlocks everything else. It doesn't allow 16 bit layers, but apart from that it'll turn Elements into effectively a full version of Photoshop.
About Elements+