If you want the absolute best example of a "solid story" in a song, start with "Dono Ne Kiya Tha Pyar Magar" . It is essentially a short story set to music with a definitive beginning, middle, and tragic end.
Best for: Understanding the roots of Hindi music. list of hindi songs