The infamous SNL skit featuring Massive Head Wound Harry has made a lasting impact on pop culture due to its dark humor and absurdity. The character's unexpected appearance and ridiculous behavior continue to be a fan favorite.