Cruise's most controversial relationship with actress Katie Holmes was his biggest failure due to Scientology, as she fled the church in the middle of the night (pictured in 2011)