Apollo was ridiculously ahead of its time and was not sustainable. The entire stack was disposable and it’s pure luck that we never lost a crew. We needed a project like the ISS to do the real work to figure out how to live in space and build long lasting space hardware.
The biggest shortcoming of the project is that we never tried centrifugal gravity. There were plans for a module but it never got there.
There were plenty of non-self-referential justifications for ISS (like growing protein crystals, or space manufacturing) that never really went anywhere.
Ironically, maybe the best justification was it shows large space structures can be assembled from small units, so large launch vehicles aren't needed. NASA has of course totally ignored this lesson with SLS.
With the current state of things, I would bet that with a fully reusable orbiter like Starship, space-based solar with microwave transmitters will probably be a cheaper option than fusion. But we should work on both because we can't predict it until both are tried. It's easy to say no to a project when we don't know what the outcome will be, but we need to take on a lot of big risky projects to see which ones give outsized returns.