4070 Super should be fairly quiet, even with a 'budget level' cooler.
I barely hear my 4070 Ti which has a standard cooler due to undervolting.
Please remember that any mention of competitors, hinting at competitors or offering to provide details of competitors will result in an account suspension. The full rules can be found under the 'Terms and Rules' link in the bottom right corner of your screen. Just don't mention competitors in any way, shape or form and you'll be OK.