I watched this movie years ago, maybe 10 years ago. It is a horror movie about a (probably newlywed) husband and wife who were authors. They move to the hotel or apartment where the wife's mother died (when she was a child) to write a book on her I believe. The dead mother keeps calling the daughter and doing a bunch of creepy stuff.
Eventually the husband leaves the wife (for being crazy I think). The most horrifying scene was when the wife took a shower and turns around and there is her dead mother, so she runs out of the apartment or hotel into the housekeeper who checks the apartment and says nobody is in there.
The ending is the wife signing books and making it big while the husband walks by and isn't making it big. BTW, This is not Psycho.