Neverwinter Nights 2: Mask of the Betrayer -- the spirit eater curse. The best execution of a harmful curse giving you powers, while also becoming increasingly problematic the more you used those powers. It even solved many balancing issues from the main game by severely limiting resting, something that could definitiely benefit BG3.
I loved it, and I really wish Larian had taken some inspiration from that mechanic.