Interestingly, Jesus Christ Himself "overlooked John the Apostle on the ballot."
John was the most beloved of the Apostles. His faith was so genuine and strong that he was the only Apostle not to die a martyr's death.
And yet when Jesus Christ wanted one of His Apostles to become "the Rock upon which I will build My Church," he picked Simon Peter -- perhaps the most flawed, imperfect Apostle of them all.
I have heard a story that John survived a boiling-in-oil ordeal. Being a confessor might be harder than being a martyr — John had the tougher thing to go through.
Peter is my favorite of the 12, largely because his imperfections and impulsiveness are easy to relate to.
So, did Jesus pick Simon to become the Rock (your capitalization)? Or did Jesus build the church on Simon's statement of faith "You are the Christ, the Son of the living God"? What is the Greek word used for "Peter", and what is the Greek word used for "rock"? Are they the same words, or was the Gospel written with two different words to show similar but different things, as Jesus Himself said two different things when he gave Simon the new name Peter while also saying "upon this rock I will build my church"?