How about Atreus Eleint? The poor guy was not exactly a looker and yet wanted to be a priest of the goddess of beauty. It then set him on a fantastic quest for beauty that led to the most notoriously abrupt ending of any FR novel ever written (IMHO).
As I recall, I hated the ending of that book so much I wanted to throw the book across the room. Only two Realms novels have done that for me.
It's been a long while since I read the history of Myth Drannor, but wasn't its downfall indirectly caused by a red dragon that was raised to be a good being, which was the symbolic key needed to release from magical imprisonment the trio of nycaloths who assembled the Army of Darkness and marched it on Myth Drannor? IIRC, that dragon later died fighting against the monsters he'd inadvertently released. Imagine being at least partly responsible for the downfall of one of the greatest civilizations Faerun has ever seen.
It's been a long while since I read the history of Myth Drannor, but wasn't its downfall indirectly caused by a red dragon that was raised to be a good being, which was the symbolic key needed to release from magical imprisonment the trio of nycaloths who assembled the Army of Darkness and marched it on Myth Drannor? IIRC, that dragon later died fighting against the monsters he'd inadvertently released. Imagine being at least partly responsible for the downfall of one of the greatest civilizations Faerun has ever seen.
That is certainly tragic... But Garnet's ultimate fate has never been revealed. Garnet disappeared and was never seen again.
We know that garnet freed the Nycaloths - perhaps some of the High Magi figured it out - but that is not something Garnet or most anyone else ever knew. We only know because of the partially omniscient history they gave. That said, I'd agree Garnet to be tragic because of all the loss of the fall - but no more so than any of the other heroes of myth drannor.