That SCP site is really a goldmine of game concepts... If they can be executed well. It'd be cool if a handful of them could be implemented into a bigger-budget horror game with a wider scope than "check out this shit before it inevitably kills you."
The site itself never really did anything for me, but I like the idea of games like this.
I always liked the idea of an SCP game being built around the player being some random D-class who gets freed during some huge fuckup, and has to figure out how to escape the site using his wits and SCP knowledge.
Hide from re-containment teams and Keter-level containment breaches. Get to SCP-082's cell and tell him that you're there to evacuate him due to an assassination attempt. Use the Book of Endings as a cheat-sheet for what containment areas should be avoided at all costs. Acquire SCP-674 so that you can fool automated security feeds into believing you've already been dealt with. Sky is the limit.