Mostly - I find a lot of these quite funny, but I think LD is the least accurate one. TOS also is one of the less spot-on ones, but I think late TOS and especially the TOS films, it becomes very applicable.
I think the LD one really only applies to the early show, and mostly just Mariner and Boimler. Later on, it's often less they lack brain cells but often use them at the wrong time, but then their brain cells are good enough they actually make it out of the situation. I'd say none of the main characters are actually particularly mediocre except Boimler (not to hate on Bradward), as we slowly find out. Maybe some of the bridge crew stay within the box of mediocrity, but we still learn to love them as characters. I might put something for Lower Decks like "Pick one from each, and make it more dysfunctional".
Considering both the description of LD and there being no SNW, this was clearly written some time 2020 or 2021.