The loser eats a full stick of butter, plain, unmelted, on camera. It takes two minutes and haunts everyone who watches for years. Documented by ESPN as a real league's chosen horror.
Budget note: this one costs nothing but dignity, which makes it a strong pick for leagues that would rather spend the pot on the champion than on the loser's downfall.