It's definitely not "just kid stuff" if it gives that impression. There's some seriously talented writers out there that can really grab your imagination.

I recall one "tale" that about a time when SCP failed to secure everything all at once, and a normal guy is detailing the world basically falling apart as long as he can.

In the right hands a lot of these stories could make magnificent movies, but that's a long shot.