The Wings of Love, Doisneau's The Kiss, Vettriano's Singing Butler… These prints have taken pride of place in millions of homes since the 70s. So what explains their enduring appeal? Miranda Sawyer celebrates the art that Britain took to its heart