50/50.

50% no. Looking at the bigger picture, it brings new fans to the artist. Thus the artist continues to grow and vice versa. The more you get, the more you grow as an artist. That will always be a big plus.

50% yes. While there may be some songs used in a terribly made meme or however the song was included, the artist ends up being only known as x viral song was used in meme haha or just a one hit wonder than fades into obscurity.