I have an extension that have to work on page load, but back in 2016 long before Chrome had that UI built into the extension settings, I disabled it on all sites by default and instead I built a UI so that the user can enable it only on certain sites.
On top of that you need to enable the extension for local files if you want, I still can't figure out why some people don't have that enabled on install.
So anyway all of my 1 star reviews on that extension are by people that simply can't figure out how to enable it despite the lengthy description, documentation on my GitHub page and a screencast in the extension's listing.
All of my 1 star reviews just say: 'It doesn't work', where it obviously works for 100k+ other people. But my point is that for whatever reason these people don't want to invest a few minutes to look around or probably they had a bad day or whatever that is, they rate the quality of a product without even using it.
I really don't think that's fair because that 1 star review is forever and it's not even about the product itself. Those type of reviews really dent the performance of an extension, because as we all know not that many people leave reviews anyway.
One possible solution to this is to simply not allow people to rate an extension without using it. Then for legitimate users to leave a review enable the rating on the extension listing page after a day. And to make things even better, and potentially push more people to leave a review rather than decreasing that number - how about showing a small popup under the unified extension button in chrome, only once, to ask people to leave a review for their newly installed extensions after a day.