Misery is in the eye of the beholder. Those who find Leonard Cohen or The Smiths depressing are, in my opinion, miserable sods. Or they are simply not listening.
You can't really play The Stones to death because you listen to it with your hips, not just your ears. Tumbling Dice isn't going to get old.... or grow up. And it does fill me with joy every time I hear it
So does Moonlight Mile. And Rocks Off. Winter. Monkey Man. Sway. The list goes on.......
The Beatles.... that is a whole other discussion. The genius there is songwriting and production. I could never get bored of Sgt Pepper.