It was basically a stunt: create something as quickly as possible with money as no object. It is extremely obvious in hindsight that the capabilities and solutions it created were not directly sustainable or efficient in the long term.
We should not clamor for some similar projects or similar technical solutions, just "because Apollo did it".
Instead we should objectively strive for reliable, flexible and affordable spacefaring.
Some of the project practices and technologies that Apollo used might be good for spacefaring unchanged as they were, some might serve as basis that needs development and others are negative examples.
We just shouldn't say "look they went to the moon with solution X" as the only justification for solution X. Solution X could be for example building a single huge rocket.