Getting a good identification of which kind of hornet it is will make a difference. There are many kinds and they eat different things and have varying levels of aggressiveness.
I love the cycles of predator-prey like the wasps that lay eggs in the tomato hornworms. However, the bee-wasp-hornets that make nests on my house and barn and shed and camper and tractor and everything else upon which the sun shines...well I wish they would go away. I didn't used to mind them, a sting every so often is no big deal, but now my husband and I have both been dying often
enough that we are allergic. I had two close calls in recent times when I was alone caring for small children and got stung and started to swell up in important places like my throat!. It was scary and dangerous.
The traps I have tried have not helped at all, I think they were meant for other members of the bee family. Keeping things out of the sun helps keep them from nesting. But I can't get the house or the barn etc out of the sun! I have heard that if other members of the api family move in they will move out, but have not figured out how to make this happen. Perhaps
mason bees are an
answer? I wish I had better answers for you, and I'm hoping someone else does! I am all for diversity of
course but I'm still wishing for less aggressive bees.