Please don't list this on a work's page as a trope. Examples can go on the work's YMMV tab.
Nightmare Fuel: Snow White & the Huntsman
Queen Ravenna herself. Holy hell. She's genuinely creepy as hell at times and one sequence involving her standing in the fire causing her flesh to be burned off is disturbing. It's all somewhat hampered by Charlize Theron's acting, though. Though reaction to Charlize Theron in the role would indicate a lot of Nightmare Fetishists.