Ultimately, you need to try all of your film options yourself and decide how they compare. Buy a 24 exposure roll of both (or all three: TMZ) and shoot tests of them - preferably the same scene(s) - and develop them the way you expect to use them, and do your own comparisons.
If you must know exactly how they stack up against each other before buying 100’ of film, then testing each first is the only practical choice.
As I said earlier, Delta 400 is absolutely my preference over HP5 (in small formats) - it has a clarity and “sparkle” in the upper values that HP5 simply doesn’t have. It’s great for many applications, but isn’t a great fit for how I like to work.
Some examples of work done on Delta 400:
PS: there's nothing to stop you from buying 100' of both (or several) film types and simply switch out the roll when you need a different film. It's a simple thing to remove a bulk roll and put in a different one.