https://www.cpubenchmark.net/cpu_list.php
This is a really useful way of judging relative CPU performance. Search for the CPUs you are interested in, and make note of the PassMark score. A score of 10,000 is objectively twice as powerful as a score of 5,000.
As far as support is concerned, if you don't care about that, then having supported hardware is meaningless. It means you can't call Microsoft or HPE with any issues. For example, to run ESXi 6.5 on a G7 you have to inject older drivers, and every time you update ESXi those older drivers will get overwritten so you have to remember to roll them back before you reboot. This works fine in a home lab, but is unacceptable (to me) in a work environment. Older versions of ESXi (that *do* support the G7) have security vulnerabilities so now your environment is open to exploits. Anything is possible, but all things being equal, I much prefer an environment that is easy to maintain and easy to keep up to date. I have no doubt that you were able to get Windows 2016 running on a G7, but I suspect you had to use Windows 2008 R2 drivers to do it? Will HPE or Microsoft support you if you run into problems? And at that point, what are your options?
As for performance, horse-drawn buggies still manage to get people from A to B, but there's a reason the modern motor vehicle became quite popular.
Bottom line, if there's nothing wrong with the app right now, and you're happy with the completely unsupported nature of the environment, why are you even considering upgrading to new hardware? For me, my time is valuable, and so is the time of the end users. If you end up faffing around with a G7 where you could've gotten it sorted that much quicker on a Gen10, not to mention the improved performance and lower power consumption of a newer server, then how much is that lost time worth?