I’s just me, but I think Led Zeppelin’s “Stairway To Heaven”, was about a woman trying to escape the Iron Curtain.
Wow?!!! That’s either a real stretch or step away from the mushrooms. I have the song playing in my head and just don’t see the connection.
“One is the loneliest number” is about heroin.
I have also come up with some interpretations that are probably unique. It seems to me that "Eleanor Rigby" by the Beatles (1966) is about an agent of the the House Committee on Un-American Activities who is investigating a fake church used as a dead-drop for Soviet spies but is liquidated by a GRU assassin. The fake priest returns to the Soviet Union only to be liquidated in a purge ("no one was saved.")
I also believe "The End" by the Doors (1967) is about the coup d'etat that overthrew government of South Vietnam in 1963--the killer is the coup leader Duong Van Minh, the father is President Ngo Dinh Diem, the sister is his sister Tran Le Xuan, etc.
Robert Plant said the song was made up on the spot as Jimmy Paige played musical pieces. It was pure improv with no storyline.