I recently tested the New member post queue and found the “Your post awaits approval” modal a bit off-putting.
And this was on localhost when I expected it to happen.
What was most disconcerting was that not being able to see the post, there was no visual confirmation of success.
I don’t know if being able to see the post would be all that much better as it would send a big “we don’t trust you yet” message to the New member either way.
I would hope most would understand it to be a general anti-SPAM measure but n any case, I do think allowing the member to see their post with a type of greyed out overlay would be an improvement.