I love the narration in Terrence Malick's movies, particularly Days of Heaven. Ditto the Wilder-penned Double Indemnity and Sunset Boulevard. Possibly the best use of narration I've seen is in A Clockwork Orange, or in Chris Marker's La Jetee and Sans Soleil.