Personally the only websites I see displacing SO on Google results are sites that reuse SO content and game Google to get ad revenue.
This is the main use I have for browser addins that block sites in search results.
Not a browser add-on but changing to self-hosted searxNG. Proxy searches to your engines of choice, filter and rewrite urls to your liking (like yt->piped, medium->scripe.rip).
You can actually pair this with a browser extension: Privacy Redirect[0].
You can setup your own self-hosted instances or existing third party ones. It's a game changer both for privacy and UX.