My scariest opponent would have to be chaos.
Orks are scary but Khorne berserkers have them beat on insane bloodshed and violence.
Nids are scary but Nurgle demons have them beat just by how they devour with diseases.
Dark Eldar are scary but Slanesh demons will rape you and torture you with things you didn't even know existed in holes you didn't know you had.
Tzeentch and his magic would just be terrifying too because you really wouldn't have any idea what was going on there.
All in all most of the armies are scary but they mostly need to comply with the sideways physics of
40k, chaos doesn's even need to do that.... and i really dont like the idea of being raped by something that even has control of whether I die or not.