Cosmic Dramas

I am not sure whether the word, "narrative," is appropriate but Poul Anderson was able to write interesting accounts of planetary and cosmic processes involving neither intelligence nor even consciousness.

See:

On Satan
The Last Planet
The Center Of The Cloud Universe
Unusual Heavenly Bodies
The Mystery Of Mirkheim
In Space
Inside The Cloud Universe
The Sky Cave As Seen From Within
In Memoriam: Summary

And there are others.