"They Feed on Fear" not only is a horror TTRPG where you play as an eldritch being feeding on the fears of a small town, but it also features great art by incredible artists such as Trevor Henderson, David Romero, and Aeron Alfrey.
Chorogaiden is a new horror TTRPG inspired by Japanese horror media such as the works of Junji Ito or the game World of Horror. Solve the mysteries of a rural town, from mysterious puppet shows to grotesque sirens, and stop the Eyes from accessing our reality.
I never knew that existed a SCP-like TTRPG that must be played using a "Where is Waldo?" book, and in its small size, it is brilliant.