It really depends on the domain. The biggest problem I've noticed is they don't seem able to filter out those shitty auto-generated spam sites for comparisons or top 10 lists. So if you're searching for "X vs Y" or "best X in 2023" you'll get absolute dross.
For other kinds of queries it still works pretty well IMO.
> The biggest problem I've noticed is they don't seem able to filter out those shitty auto-generated spam sites for comparisons or top 10 lists
That boggles my mind as well. Google already knows which media are actually relevant as a source. For example, if I want good reviews for electronics products, I'd go for Heise and Golem, for everything else Stiftung Warentest. Google could easily compile a list of reputable media for each country and prioritize these, but they don't - I suspect because they enjoy all that sweet sweet ad money coming in from blogspam sites and less-reputable media.
For other kinds of queries it still works pretty well IMO.