Not terrifying, but Thanos had some good points, also Ultron had his heart in the right place and he was terrifying in the What If episodes
Edit: I'll add Gorr the God-Butcher as well, even though the new movie was boring, he was pretty scary and his motives were fair, he was just giving the Gods what they have given others for centuries