There's no way in hell I'd use the Heavy Sniper in the defend-the-hacker portion of the Doomsday (Act III) Finale.
They are very different tools for different situations.
And that is where the Heavy Revolver MKII comes in! Just slap on some HP rounds and say bye bye to all those bullet sponges as they die easily. Even the juggernauts die easily.