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 while he was shooting a movie in Iceland