Art expert and hermit Sister Wendy visits six of Britain's finest art collections and discusses pieces by Vecchio, Titian, and C'zanne