For me it really depends on the writer. For example the Dresden Files books are all ‘narrated’ from Harry’s POV and it really works. Othertimes it is less great. I keep thinking doing one of those Dracula style epistolary stories would be cool, with all the diary entries and letters and newspaper clippings.
“Witnesseses report a woman turning into a wolf. The relevent authorities have been informed.” etc Only much less shit than that sounds.