Well maybe im Wrong but for Me Astarion should Never Had a Good ending.. he is a Thief and a Vampire.. theres no GOOD in him.. i all my games when i was playing a good dude by the time i get to finish his quest when i refuse to help him becouse i will not create another moster im a hero.. he just made me kill him.. i Beleave that He never was supposed to be played as a Good Guy like a Said.. he is a Vampire and a Thief.. dude in Any tabletop he at least would have been a Neutral evil..meaning he was never supposed to be GOOD. But ho knows maybe im Wrong and yu guys are corret.. i just always felt that he is a Companion Perfect for a Durge game or a Evil one becouse in all my evil games he basicly become my right arm man and minthara my Demonic Godess. RS and Fun Fact He was like a Devil in my shoulder the entire game like in old Cartoons.. haha
If you go by DnD rules then yes, vampire spawn is neutral evil with their emotions twisted just like true vampires. However, you're missing a CRUCIAL DETAIL here, Larian has bent a lot of rules in BG3. They chose to make Astarion a SPECIAL SNOWFLAKE, a spawn with a chance for redemption. Throughout the game depending on your choices you CAN make him a better person, you will not be able to make him lawful good, but neutral or chaotic neutral or possibly chaotic good?
So with him being so "special", Larian gives you a way to make him a better person just to spit in your face at the end of the game... so, why go through all that? Make people hope for a good ending, have all the pieces set in the game hinting that you CAN get it. Only to make it all NOT matter in the end, and worse turn it into a cheap childish joke at the docks?
If they wrote him the way a vampire spawn is supposed to be in DnD, then yes, I don't see much possibility for him all of a sudden turn to the good/neutral side. But they make you invest and put an effort in to helping him to be a better person, but then in the end you've basically come a full circle back to square one minus the Casador's hold on him. He is still a spawn with all the shortcomings of being one and no solution in sight...