Have searched my playlists for artists that meet the thread title and all I can come up with is a couple from a list where Paul Weller has provided songs (or collaborated with) other artists. He often hears a voice and thinks he has a song for it that he wont use himself. Neither of these are artists that I would listen to anything else of theirs.
Olly Murs - Let Me In
Gabrielle - Why
Plenty of 'one song' artists but I wouldn't say I don't really like them. They just had one song that I do like listening to and a bunch I could take or leave.