Games like Song of Horror: Complete Edition

If you finished Song of Horror: Complete Edition, the closest matches are The Casting of Frank Stone, Eternal Darkness: Sanity's Requiem, The Medium, Narcosis and Song of Horror. All 7 share its adventure genre and are ranked by how closely their themes and modes overlap.