Developer Tea Powered Games has some great ideas here, and I can't help but hope that its next title be something like a murder mystery game! But if you do fancy sliding into the shoes of a struggling writer, you could do worse than play Dialogue: A Writer's Story.
Muv-Luv Alternative is a great title within the genre, as it explores some really interesting sci-fi and political ideas. But at the end of the day you are mainly along for the ride for unsavoury reasons, and that can sometimes eat into the seriousness of the plot. I mean, just look at those uniforms!