Another system that does it well imo is Shadowrun. In 5th edition (never played the others) when you cast a spell you can take mental damage. If you cast the spell on a weak level you are fine but if you go full-out then you can KO yourself pretty quick. Especially if you roll bad on your damage resist roll.