I play Cron's and Tau so I don't have any Super Units par say....
But for most Useful I'll go Lord with Veil for the Crons. The added mobility is awesome for many tricks.
And
Pathfinders. Yeah they are fragile but the markerlights tie together the whole army. And the rail rifles make Marines squirm.