More of a case of what it can't do. It doesn't make the tea or coffee.......

but it can be used to remove just about anything from audio. Clicks, thumps, crackles, reverb, etc etc., Isolate audio, split out mid and side channels, etc. etc., time and pitch stretch, recording, mastering. Chances are if there's something you want to do to a piece of audio it can do it.
I don't use it a huge amount and have only really learnt a small proportion of what it is capable of. It's like R-mix on steroids, only mega-steroids. Much of it automated to make life a little easier. Yes other programs can do similar stuff but it might mean more than one program. It's all in one place in here and arguably easier/better at it.
Whether it's worth that sort of money is in the eye of the beholder though.