Id be tempted now to use LR and Elements
anyhow
I use photoshop to do things like posters, text, and that sort of thing that LR does not support. For me, that's about it these days
LR's NR is lousy, but LR 3 is much better. I would recommend Neat Image, Noise Ninja and Nik Dfine 2.0 as plug ins.
Other LR Plug In's Id recommend is any plug in that integrates LR with you online gallery,
flickr etc
LR/Mogrify
LR/Enfuse
There are 100's of presets that you can get for free from all over.