The room correction software can help smooth out FR in the final step of room tuning your system. You still have to do speaker placement, room treatments, component matching, etc. Yes, I think it a good investment. As for what is achieved you can see the FR before and after graphs in my system profile.
I have used both Audyssey Pro and ARC and have achieved good results with both as long as you use a calibrated mic.