The absolute cost isn't the problem, it's the value that we're getting from it. SLS and Artemis are both incredibly expensive and ramshackle programs, and regardless of how bad the rest of the USG might be in terms of their cost, or value, if you are a true space fan and a true American space fan, you should want this little corner of humanity to hold itself to a higher standard.
Acceptance of over costing and under delivering is exactly why the US is stuck with SpaceX as its prime space launch provider. It's only through the miracle of the vanity of billionaires that there's even a realistic second choice (Blue Origin) that might develop.
It's also this type of attitude that let's us be in a situation where we honestly don't know how well the heat shield will work on reentry (SLS launches are so expensive, and so slow to build and prep to launch, that we cannot fit in a uncrewed mission between 1 and 2 to test or validate fixes or models).
If Artemis as a program succeeds, it will be despite the incredible graft, pork, and ass covering, not because of it. I want Artemis to succeed because the achievement will be beautiful and amazing, and I want everyone to be safe and sound. I want Artemis to fail, to force a reckoning. I still believe that America has great things to offer to the world, but it's not going to be able to do that by muddling it's way through and cobbling together random pork filled programs into a vaguely inspiring shape.