One of my long-time favorites is Troy's Keeper of Magic: https://imgur.com/a/yoKPeub
There's also an optional lewd DLC: https://imgur.com/a/BoACmQp
I love it because of how it feels like seven different CYOAs that have been fused together. Troy has stated that all the powers and abilities were meant to synergize and play off each other, and it really shows. For over a week after I first saw it I kept being struck by sudden realizations that had me rushing back to my PC to edit my build- discovering new ways to play with the selections to get all the things I wanted.
The one that I love showing to other people though is Hexably's Overmind CYOA: https://imgur.com/a/09IOpkb
I looooooooove the fantasy of it. The idea of being the overlord of a zerg/tyranid hivemind is incredibly compelling to me.