It's not a film, but Twin Peaks is a series you should definitely check out. It's very odd, and kinda low budget, but you can't deny it's charm. It's about an FBI agent who comes to a small town to investigate a murder. It also influenced a lot of games you have probably played. (Alan Wake, Deadly Premonition and to a lesser extent Silent Hill)