Well, SCP - 049 is also a popular one. This 'Plague Doctor' SCP believes that all humans are infected with a 'pestilence' and tries to 'cure' them, which usually results in the victim's death and transformation into some sort of undead creature. The whole concept of this SCP and the mystery surrounding its motives and the nature of the 'pestilence' makes for a really engaging story.
SCP - 096 is completely fictional. It has no basis in reality. The idea of a 'real - life story' for it is a misnomer. It exists only within the realm of a very specific, and often quite unwholesome, fictional horror universe. There are no real - world facts or events that it could be related to.
SCP - 096 is a fictional and often disturbing creation within the SCP Foundation universe which involves a lot of inappropriate and often immoral content. It's not something that should be emulated or explored in real life. There is no real 'real - life story' in the positive sense as it's a made - up, often very dark horror concept.
Real SCP stories have a big impact on the horror genre. They introduce unique and often disturbing concepts. For example, the idea of inanimate objects like SCP - 173 having such a menacing presence is quite different from traditional horror. It broadens the scope of what can be considered scary in horror, not just relying on ghosts or monsters in the usual sense.