Sex, lies and cardinal sin? A plot like a Dan Brown novel and characters including the Pope's saint-maker, his 'Mata Hari' fixer, and a secret cabal accused of siphoning millions from Vatican coffers. The result? A most unholy scandal, writes GUY ADAMS