I found a guide for the 14 "Various Artists" songs - https://gamefaqs.gamespot.com/ps5/344537-alan-wake-ii/faqs/81253/collectables-misc. I didn't verify it yet because I'm too early in the game, but if this guide checks out, then perhaps it should be incorporated into the wiki, maybe even in a new page dedicated to this collectible type.
Alan Wake Wiki