"Even" implies a consensus that I don't think exists except in the minds of people who find hating something recreational. Siri works pretty fucking well in my experience, but that experience is colored by my understanding of what it is, and what it's good at.
You have to be aware of what makes a good Siri question or task. Technical people tend to understand this implicitly; we are, after all, talking to a computer, and computers are notoriously literal and have trouble with implied contexts, etc.
I think I've talked about this here before, but my wife often phrases questions to Siri in a way that results in the dreaded "I can send the results to your iPhone" non-answer. One example I remember happened when we were idly talking about King Charles. My wife asked Siri "how old is king charles" and got the non-answer. I asked Siri "what year was king Charles born" and got hard data back.
It's that kind of thing.
In the narrow case of music there's more to complain about, I guess, but the base problem is specificity and name collision. It doesn't seem to always pull the example of any given non-unique name that I might want; sometimes I wonder if what i get is just random.
If you ask for "Take Five", you MIGHT get Dave Brubeck. I'd argue that, in the absence of something specific, you SHOULD get Dave Brubeck, and moreover you should get the album cut from "Time Out." But Siri doesn't really agree, for whatever reason.
OTOH, if you ask Siri to play "Take Five from the Dave Brubeck album Time Out" you'll get exactly what you want.
Siri excels in simple, discrete asks or tasks, though. We both routinely use it to add things to the shared shopping list we keep in Reminders. That's kind of awesome, and beats the old norm of "go find a pen to add this to the list that you may or may not remember to take with you when you go shopping." Setting timers or alarms verbally is awesome. The list goes on.