He wanted to be a librarian.

Pope John Paul II asked him to continue as Prefect of the Congregation for the Doctrine of the Faith (and the Holy Spirit chose him to succeed John Paul II as Pope). Some interesting footage of Blessed John Paul with Joseph Cardinal Ratzinger.