Lower Decks, per usual, had the best take on this trope.

in the in-universe parody show “Wormhole X-treme”

That whole episode was such a gift.