One theory I always found fascinating was the biblical nature of Shadow of the Colossus. Of course, it's not a theory anymore as it has been confirmed to be the case now, but it was fun piecing things together and making connections back when it wasn't.