Aside from White Night, any other recommendations?
So many. Looking through all the crap on moddb, it's hard to believe that there are actually a LOT of really good custom stories. Most of them are total conversion mods though. I'd recommend Amnesia Hill, Abduction, Tenebris Lake, and Disponentia (all of which are on moddb)