Art expert and hermit Sister Wendy visits six of Britain's finest art collections