Despite being one of the canonized classic episodes of Star Trek, "Darmok" is incredibly goofy and campy. I watched it again last night and couldn't stop thinking "Even in the 90s how did they take this seriously?" It's still out-camped and out-goofed by a number of Original Series episodes, but is easily the silliest TNG episode I can recall.
It's ranked as #5 greatest episode of all time though. So there's some disconnect there.
I'd say literally
any episode in which something Wesley was fucking around with happens to save the day from some space anomaly is more cheesy than this. They just dress those episodes up with more "Days of Our Lives ... in space" window dressing, so they're more palatable.
Q episodes are way more cheese than this, too.
The reason it's highly ranked could probably be deciphered. Rather than featuring some "science-fiction-y" thing such as the ship being trapped in a space vortex or similar, and having a techno-babble deus ex machina solution provided by a little boy, it's about communication, language, culture and it's personal rather than scientific. It's one of the few episode in which the difficulties of communicating with alien life
isn't hand-waved away with techno-babble. And this is why it's highly regarded. It
doesn't quite fit in Star Trek canon, because it is actually a piece exploring something more thoroughly that's normally effortlessly glossed over in the rest of canon.
EDIT: to give you an idea of the disconnect between something like Darmok vs the how "universal translator" works, consider how
all the other main races have
not only base-10 numbering systems, they actually use 1000s grouping for all their bigger numbers. This is canon for Klingons for example: the Klingon number system has direct words to translate thousand, million, billion and so on. However, we don't even have that level consistency
on Earth. Not even among cultures who agree we should be using base-10. For all the Trek love, the other races are super-simplified compared to the diversity of culture on Earth. Darmok is highly regarded because it effectively abandons canon to try and tell a truer story of how hard it would be to communicate.