Differences between supernatural and non-supernatural horror

You've hit the nail on the head. That's what the best horror does, and Ramsey Campbell is a master if it. His short novel Needing Ghosts is exactly about uncertainty over the MCs sanity and his reality, and maybe a masterpiece.