The mysteries in the core book are a great starting point. I'd say Out of Time is a good book for a full campaign too!

I've already played all the published mysteries I liked for TftL. I agree that they are great! I'm more looking to find scary modules/mysteries, less for system recommendations.