I must admit, I find him pretty enthusiastic. That's one thing I have to say in favour of most of the video presenters that I watch on whatever subject ~ they're enthusiastic. As with most things, I'll agree sometimes and disagree vehemently much of the time.
The irony for me about what makes "X" song great is that the very same thing that makes one song great is precisely what also makes another song not great !
Personal preference.
Also, if I didn't record my own stuff or have an interest in recording, I don't know how sure I am that these deconstruction/explanation programmes would be something I'd ever watch. Having said that, even as a teen, I was fascinated by stereo and the way one could isolate one channel from another on my Dad's Panasonic and I was also interested in instruments so maybe I would've watched these things anyway.
I do agree that Rick doesn't seem to specify what makes the songs great but by breaking them down the way he does, it's like he's showing separately all the bits that together make greatness. It almost goes without saying.