All brands make mistakes and have their inherent problems or limitations - Their BIGGEST Mistakes: Canon, Nikon, Sony, Panasonic & Olympus
Some brands do certain things better, and other things not as well, there are always compromises, and more features always cost more money. It's just a matter of choosing what compromises you're happy to live with for the budget you have, and figuring which brand is the best fit.
Nearly every internet forum for every pastime is filled with meaningless arguments and disagreements over 'the best tool' above all others, which just devolves into emotive tribalism that hinges on brand loyalty. Kind of funny when the companies they're fervently defending have no idea who these people are!
For companies to be successful, they need to differentiate themselves from their competitors, point of difference is critical. They adopt different business strategies to achieve this, which may appeal to some consumers, repel other,s or leave them indifferent, not caring either way.
From what I can see, and is mentioned in the video I've linked to, Sony tries to appeal to its customers by packing lots of tech into their cameras, competing on specs, which really appeals to gear heads a lot. Apparently, the ergonomics of their cameras and software (menus) aren't great, but they do other things very well.
The biggest criticism leveled against Canon, other than being stingy and not including lens hoods with their non L-series lenses (everyone else does), or their overpriced RF L-series lenses, is that they've made the mistake of competing with themselves, intentionally crippling their camera products so they don't cannibalise sales from their extremely expensive cinema line cameras. They've extended this concept of market segmentation in their hybrid cameras (DSLR and mirrorless) by stripping out features from lower model cameras to make the more expensive ones more appealing.
All my gear is EF and RF Canon, other than a Sony high-end compact camera, I just use what works for me, and that's what others should do too!