The most effective surgery to repair drooping eyelids is called blepharoplasty, which involves removing excess skin, fat, and muscle to tighten the eyelids.