There's a lot that's not covered in a parametric search listing. In your link, picking a core doesn't tell you how good the peripherals are. (Digikey's parametric search [1] does give you a lot more information about what peripherals are available where Mouser doesn't even mention it). Clock frequency doesn't tell you how many cycles the instructions take. And none of that tells me anything about power consumption or performance in a typical application, or especially about the usability of the toolchains.
If answering "it depends on what you need to do" requires a lot of domain expertise to evaluate, there's definitely a place for summaries like this!
There's even lots of sub-dollar MCUs out there too. As the author notes, picking the best one depends a lot on what you need to do.