This thread is fascinating and probably explains much about how people respond to the various iterations of Trek. Personally, I have little interest in the “lore” as people seem to be using it. I thought Discovery’s deep dive on the Klingons was deadly dull, but I find many of TNG’s Klingon eps the same. The Borg got less and less interesting the more we saw them. I don’t need to visit Andor or explore the origins of the Andorians’ secret ice powers. It’s fine if it happens in the course of a story, but, on its own, I don’t find that sort of thing of particular interest. All the alien stuff, all the lore, all the filling-in of backstory is interesting to me only to the extent which it lets us explore our characters, their values and the human condition. I think that’s why I like TOS so much — it uses its sci-fi trappings for metaphorical purposes rather than as ends unto themselves. Some folks these days see that as a failing, but, to me, that’s a big source of the appeal.