It's neat to see that SCP also resulted in some... reasonably novel thinking? Thanks for sharing, I'm going to pick this up.
It's worth seeking out the "top rated pages" section of the wiki, especially when you are starting out. This can help introduce you to some of the more famous SCPs that you are likely to see reference elsewhere.
On the other hand, one of the charming things about the SCP articles is just how different and weird they can be. So don't be afraid to just read around. For example, one of my favorites is a woman who basically has a portal to an entire underground bunker in her nostrils.
The SCP wiki has resources for how to write an SCP article. A lot of these are EXCELLENT if you are interested in learning how to write weird fiction even outside of SCP (e.g. the D&D campaign you mentioned). For example, one of them discusses different ways that you can structure stories to subvert expectations.
The video game Control is not set in the SCP universe but is highly influenced by it. It's a lot of fun.
There are a number of SCP games available on Steam. They tend to have some jank due to being fan projects. However, the end result is often very cool. In particular, many of them have procedurally generated levels which works well with the wide variety of anomalous phenomena that they can add.