A fringe favourite for his Houdini and Dracula spoofs, ‘comedy’s best kept secret’ has finally had his breakout moment – in the least likely fashion