Yep, unhappy endings can be good if they are done well.

The current ones are not.
(And honestly, I don't think Larians writing is good enough to pull it off).