Again I was there, watching the show and it's contemporaries. Campy was Batman and Lost In Space not Star Trek. Because it's cringe now doesn't make it camp back then.
This is interesting because while I wasn't around at the time, my parents and grandparents were, and they loved the show but found it always quite funny in a heightened reality way. My dad actually first met his best friend by pretending to mind meld with his school backpack, replicating Nimoy's "PAAAIIIN".
Maybe it feeds back into what we were saying earlier about cultural gaps - Star Trek's always come across as fun, dreamlike, and amusingly melodramatic to me (which doesn't preclude it from also working as compelling drama). Kirk yelling "WE'VE GOT TO RISK IMPLOSION!" and beating the shit out of Spock while Spock cries about his mother is very funny, even as it simultaneously works as a genuinely tense thriller plot.
I assumed that was baked into its design - I mean, they made epsiodes like "A Piece of the Action" and "Triskelion" which seem to be clearly made to get a laugh, and Shatner's performance, while unironically good, is a universal source of parody - but maybe that reaction is more common in non-Americans somehow, in the same way DSC's odd corporate-therapy-speak tone jars with international viewers, I don't know.
No it wouldn't be LOTR, because it wouldn't have those fantasy elements. But is can be the same story with all the same beats. Same for Sopranos 1600s. We have seen Shakespeare's plots adapted into 1950s New York, Medieval Japan and an alien world. This is no different.
Again, I have to ask where else you've seen
Gothos or
City done outside sci-fi/fantasy. I genuinely can't think of any other "godlike boy toys with people, turns out to be something else" plot. I mean, "The Most Dangerous Game", but not really, and the twist where the captor turned out to be a kid playing with his pets is the crux of the entire story and is incredibly difficult to replicate without magic or aliens.