After years of being profoundly unfashionable, one of the most important British figurative painters of the 20th century is ripe for reappraisal