Tate LiverpoolFrom his flaccid, semi-modernist daubs to his visions of Olde England, John Piper was about as refreshing as a cup of weak tea. But the war, and its bombed-out buildings, did give him his finest hour