There are two ways to use a Karthus Ult.
-
To initiate from a distance. Like tell Bot Lane "Go now! I'll Ult." So they are diving in at the same time you Ult. This is where it can be Healed, Negated (Zhonya's, for example) Tanked and all the other stuff you said, BUT you have your team wailing on them also, giving them a nice advantage in that Fight.
-
Clean Up Duty. You know, AFTER Abilities are blown, Mana is Low, Summoner's are spent and most general ways to escape the Wrath of R are no longer available.
If you use the Karthus Ult in Situation 1, you shouldn't expect Kills... but that you may well have turned a fight for your Team (a good thing).
If you use the Karthus Ult in Situation 2, you are damn near guaranteed to wipe up Kills (a good thing).
Also, name 1 Champion in the game with an Unavoidable Ult. Just one, that Banshee's, QSS, Cleanse or a Blink can't solve, that actually Targets an Enemy. You don't think an Unavoidable Ult is... you know... a bit much?