Romancing the Stone
A lot of great suggestions^^. I love Wonder Boys too, based on the novel by one of the best writers not only of our time but I think any time, Michael Chabon. If you want a look at the uglier side of a writer's life that looks at alcoholism, The Lost Weekend with Ray Milland is a great one. And one that I don't think has been mentioned but one of the best movies I've ever seen, period, stars the wonderful Charlotte Rampling, Swimming Pool.
Ooh, yes! Swimming Pool is marvelous. Wonder Boys too. Are you me? ;-)