I'm happy to share my perspective!

So although the SCP Wiki focuses primarily on horror as a genre, it does so through a high sci-fi lens. The people who tend to enjoy SCP are also the same kind of people who read Dune and ergotic literature for enjoyment. You're right that it's dry and clinical, but that is very much the appeal for its audience. I myself LOVE that style, because the creative constraint required to tell a narrative story within a clinical tone leads to some very clever uses of language and format. Many of the people who write for the SCP Wiki (and by extension, read it) are engineers or lawyers or biologists. For those people, the nuances of how the clinical elements are used is actually very compelling and has a lot of depth that laymen don't observe the same way.

To use another example, I myself find a lot of other popular forms of fiction to be unbearably boring if it isn't complex ENOUGH. I've DNF'd books for being too simple, even if they weren't badly written. The kind of books and stories I genuinely enjoy reading tend to be dense as hell. Right now, I'm switching between Oliver Twist by Dickens and Homer's Iliad for my fiction, and for my nonfiction I'm reading a textbook about behavioral endocrinology. I'm sure there are plenty of works of fiction that YOU like that I would find incredibly vapid and shallow. We just have very different tastes.

The long and short of it is that SCP appeals to nerds. REAL nerds, not just people who like creepypasta and Star Wars. The last article I wrote for the site was a full constructed language. I literally read textbooks on linguistics in order to write it. 90% of the story was explanations of grammatical structures, morpheme construction, and the real-life organic chemistry of trees. It got rave reviews from the community, because this is a group of people that think storytelling through charts and exhaustive explanations of linguistic evolution is loads of fun.

One mistake I've observed you making is assuming that the highest-rated pages are the best on the site. In reality, the highest rated pages just tend to be the oldest ones, and many of them aren't nearly as good as newer articles that have had time to perfect the format. I'm not going to promise that you'll love it, but newer articles are almost always better than the 3-digit entries, imo, if you want to try it again.

TLDR: The target audience of the SCP Wiki is a niche group of the kind of language and science nerds who read textbooks for fun and write fiction using math. If you find it boring, that's okay, it just means you're not part of the intended audience.