It undoubtedly provided a lot of money which helped build our infrastructure and the Netherlands wouldn't be what it is today without it - it also shows exactly what happens when the generated revenues are spent immediately. Now that the gas supply has been turned off (due to earthquakes and the government's terrible handling of those), we are scrambling to look for other streams of revenue and other gas sources (because our home heating infrastructure is largely gas based).
As someone living in Groningen, the way the government handled this is a major reason why most people I know (and myself included) have mostly lost their faith in politics and the national government as a whole.
From wikipedia:
The presumed mechanism is that while revenues increase in a growing sector (or inflows of foreign aid), the given economy's currency becomes stronger ("appreciates") compared to foreign currencies (manifested in the exchange rate). This results in the country's other exports becoming more expensive for other countries to buy, while imports become cheaper, altogether rendering those sectors less competitive.
So the Netherlands should be thankful for the Euro, which took away those effects on their local currency.
While historically true, we're approaching an era where it no longer is.
Our oil fund was set up such that the government could only ever spend at most 3% of the annual yield[1]. This seemed like a conservative approach, however it seems they didn't take into account just how large the fund would get. As such, even using less than the 3% limit, the oil fund money constitutes a large fraction of the national budget.
In the national budget for 2025, the oil money pays for 20% of non-oil expenses[2], and it's just increasing each year.
As such it does seem we're starting to get high on our own supply, just in a more roundabout way.
[1]: https://www.regjeringen.no/no/tema/okonomi-og-budsjett/norsk...
[2]: https://www.regjeringen.no/no/statsbudsjett/2025/statsbudsje...
[3]: https://www.regjeringen.no/no/tema/okonomi-og-budsjett/norsk...
What I’m saying is Canada has the potential to generate more hydroelectricity but environmental concerns largely delay or prevent further expansion.
But if you instead ask for "another oil producer that could fully cover it's local demand with energy sources not from hydrocarbons" a lot more nations would be included in the answer such as United Kingdom which has abundant wind, decent solar, some nuclear, and some potential hydro.