It's a pretty damn good controller, but has way too many limitations and quirks to be the greatest. Unlike a lot of people I love the size and the weight. I also get a huge kick out of the speaker, it adds another level of immersion to games that take advantage of it. It also doesn't have the dogshit Xbox shoulder buttons, which is nice. What I don't like is the abysmal battery life, good God is it terrible. I have 3 Edges and could run through all three of them before i used up 20% of the battery on one of my Elites or like 1% of a Switch Pro controller. The triggers feel super cheap and flimsy unless a developer uses the adaptive triggers, which many don't. I also cannot stand the fact that Sony won't get their head out of their asses and properly support the damn thing on PC. It's a gimped ass controller on PC, none of the functions work unless you plug it in, and even then they aren't as good as on PS5. Overall support is still lagging behind the Xbox controller, which is still basically the universal default. Even the app Sony released for PC is as barebones as possible.
So, yeah, I love the controller, but if you asked me if I could only own one controller it wouldn't be the Dualsense, and to me that eliminates it as the GOAT.