My biggest take away from what I think OP is trying to say and how I feel as well. Is that yes there are times the game feels like a fairy tale story instead of a gritty dark fantasy story. It doesn't bother me as much, as the story still remains as the story and the action of the game is totally separated by the music score and its own elements. I'd have to say...its sometimes the female narrator that makes the game feel...like a bedtime fairy tale story. Mixed with the funny and silly quirky things you can do, some narrations are very sleep inducing. Not in a bad way, but in a nice cozy fantasy bed time story way.
Well I checked what Terry Pratchet wrote, but I classify him as short parody writer or if not parody then SCIFI writer.
Baldurs Gate 3 is medieval fantasy and not SCIFI.
I think it is a shame that Dungeons Dragons writing has gone down...
Yes there are some writers like R.A Salvatore used to be a fan of his older books and then lost interest in his work at least a bit. Yes there are other good Dungeons Dragons books but few can match the original Drow story of Drizzt Do Urden the first 3 book and the 3 books after that Icewind Dale...
I enjoyed the 9 first books with Drizzt Do Urden but in time it gets boring he is invincible and never dies.
Cleric quintlet 5 books is also good story with a Cleric Cadderly as main character.
There exists separately a series of Harper books with many different authors they are separate stories each book and I have read all of them 16 books.
The Harpers series
The Parched Sea (July 1991) – Troy Denning
Elfshadow (September 1991) – Elaine Cunningham
Red Magic (December 1991) – Jean Rabe
The Night Parade (June 1992) – Scott Ciencin
The Ring of Winter (November 1992) – James Lowder
Crypt of the Shadowking (April 1993) – Mark Anthony
Soldiers of Ice (December 1993) – David Cook
Elfsong (January 1994) – Elaine Cunningham
Crown of Fire (April 1994) – Ed Greenwood
Masquerades (July 1995) – Jeff Grubb & Kate Novak
Curse of the Shadowmage (November 1995) – Mark Anthony
The Veiled Dragon (June 1996) – Troy Denning
Silver Shadows (June 1996) – Elaine Cunningham
Stormlight (October 1996) – Ed Greenwood
Finder's Bane (July 1997) – Jeff Grubb & Kate Novak
Thornhold (August 1998) – Elaine Cunningham
I really also tried the 90 ies released The Daughter of The Drow and found first book to very interesting, but already on second book in that triology have hard time to finish that book.