Money is a limited resource and I don't think NGI has proven to be a good investment. They made the same sort of embarrassing mistakes your average VC fund would make like BS blockchain ideas. A lot of uninspiring "research" where some of the deliverables is some open source software that no one ever uses and for which development stops after funding runs out. There seems to be something rotten about the open source…
But the problem with research is... it's hard to predict where it takes you. At some point you realize that the project you got funding for is a dead end, but you can do a really cool spinoff that becomes successful but is not technically the same project.
Another problem with research is that a lot of it is exploitation. You can't get a grant for just exploring random things and seeing what happens. But at the same time is a vital part of research - so official grants need to fund a lot of "underground" research, that may or may not mature into an official product. It's hard to estimate is a money is well spent by looking just at the official projects.
... And yes, many of projects are actually wasteful. Bureaucrats are really bad at estimating what counts as a valuable project and what is actually a sham moneygrab. In our case we are known for delivering so we often "win" when we start, but often random shell companies with the hype of the week come dangerously close.