>>92829
>I mean fuck it, I'll read through old copies of Billboard if it's the only way
Honestly, you answered your own question here. They have archives that are easy enough to navigate. Between Billboard chart archives and wading through countless compilation records put out as label promos, there really isn't anything out there like what you describe that I know of.
https://www.billboard.com/archive/charts
I agree, though, classic rock/pop stations are greatest hits trash. It would be an undertaking, but it would be possible to put together a playlist of hits through the years (or fuck even break down years and individual months if you want to really sperg out) that didn't stand the test of time/record company bullshit.