@ Raja: So I guess the bottom line is that all alternatives need to be tried out and then you select the one that is best for your camera
. "Noise makes an image look sharp" - I agree on this, however my problem is that any kind of noise reduction makes the image look very soft. I though the perhaps it was my cam (sony NEX 6) which was the culprit but I've been checking out the raws posted here and 100% crops that websites show and that is not my problem. So I guess it has to do with my settings/shooting technique or my post processing technique.
@Kaz: Read through the comments and there seem to be plenty of free alternatives to lightroom for windows too (lightzone is a often mentioned name). If someone is using any of these post your observations here and let us know if it's worth trying out.