It appears in shows and movies like Miami Vice, Friends, Captain Phillips, The Story of Us, and countless crappy Idol type shows. Every time it's in a soundtrack, it's to signal the deep infatuation between two characters. A more historically accurate use, however, would be signaling the love between a character and someone else's wife.
See, Clapton wrote the song in the late '70s for Boyd, his then-girlfriend. Reportedly, he was waiting for her to get dressed one night and instead of complaining that she should have started getting ready 30 minutes ago, he just wrote a classic song.
This was not a new occurrence for her, though, and her romantic history with famous songwriters was a long and tumultuous one. Years earlier, in 1968, George Harrison of the Beatles had written the song "Something" for his then-wife ... also Pattie Boyd:
That's "Something" as in "Something in the way she moves ... " aka, another of the most romantic songs in history. Harrison later changed his story and denied the song was for Boyd, but you would, too, after what happened next.