Neil Diamond- Sweet Caroline
Diamond said that a magazine cover photo of Caroline Kennedy as a young child on a horse created an image in his mind, and the rest of the song came together about five years after seeing the picture.
Rod Stewart-Maggie May
Stewart recalled: "Maggie May was more or less a true story, about the first woman I had sex with, at the 1961 Beaulieu Jazz Festival."
Pure Prairie League- Amie
Craig Fuller’s ode to an on-again/off-again relationship
Neil Diamond- Cracklin' Rosie
The lyrics suggested to some a devotion to a woman of the night but in actuality, Cracklin' Rosie is a type of wine drunk by a native Canadian tribe.
Looking Glass- Brandy (You're a Fine Girl)
The lyrics tell of Brandy, a barmaid in a port town. She wins the admiration of many of the sailors, but she cannot return their feelings – the love of her life was unwilling to abandon his true love, the sea. It has been suggested that the song was inspired by the real life story of Mary Ellis, whose grave resides in New Brunswick, New Jersey, where the band was formed
Simon & Garfunkel -Mrs. Robinson
In the film The Graduate, listless recent college graduate Benjamin Braddock has an affair with an older married woman, Mrs. Robinson.
Ozark Mountain Daredevils- Jackie Blue
Larry Lee was sitting at a piano playing and singing a song about a mysterious friend of his who sometimes dealt drugs on the side. Their producer loved the melody and thought it could be a smash hit if the lyrics were altered to be about a girl and the drug references downplayed.
Fleetwood Mac- Rhiannon
Stevie Nicks will tell audience members that Rhiannon is a song about an old Welsh witch.
The Beatles- Michelle
Michelle, ma belle, may be a girl McCartney knew but for now, these are just words that go together well.
Creedence Clearwater Revival- Proud Mary
Proud Mary"was arranged from parts of different songs, one of which was about a "washerwoman" named Mary.
Song info via Wikipedia