He's one of the best modern sci-fi writers. The whole collection of short stories here is fantastic, as is the "Anti-mimetics division" series he wrote over on SCP wiki.
Before reading the antiemetics series I had always considered SCP to be an awkward xfiles style fan fiction collection, I'm still looking for more to scratch that itch.
The quality of the SCPs has increased over time, by and large, though there were always outliers. A good way to find the better stories is to look at the Exploring series on Youtube; for instance, https://www.youtube.com/watch?v=8pJUm4lKOhE