I currently do not have any up to date software for PP hence all I have been using for the past two years is Nikon View NX2 and a trial version of Capture NX.

I shoot quite a lot at night and in available light, and I have a growing archive of images that need help with noise, distortion correction etc.
Looking forward, I also want to try my hand at more sophisticated PP, combining different exposures of the same shot, etc. etc.

Looking around at what is available, I was thinking of using DXO and Photoshop / Lightroom is some combination.

Will this make for a complete set of software that will cover everything?

Do these two work together well?

Any comments or alternate suggestions will be appreciated. [I realise there are many answers to the wider question]
Thanks in advance