These peculiarly animated blooms, both remedial and domestic, have become surprisingly well rooted in the artistic imagination – with Lucian Freud and Daphne du Maurier among those entranced by their bounded wildness. Our floral historian tames them into prose