[imo] the whole point of counterpoint in traditional music, is that it should accompany the melody, not overwhelm it.
if it is a song, my most important consideration is that what ever is happening musically is not distracting from the listener, listening to the words.
the song[imo] should at no point be just a vehicle for the musician to show off how clever he is