David Tennant and Michael Sheen are still a dazzling demon and angel double act – but everything else about this controversial finale is smug, grating and stale