Your GPU will hold your CPU back, but that being said your GPU will be fully utalized. For gaming a CPU bottleneck is usually what brings problems with it. Your CPU can feed your GPU enough data to fully utalize it. It just means that your CPU can handle more powerfull cards.
From what I can find the S24 Ultra has an Snapdragon 8 gen 3 no matter the region. What region are you in OP?
The regular 24 and 24+ are region specific when it comes to the SOC, for example Europe gets the Exynos 2400 and America / Canada? get the Snapdragon versions
Be Quiet! Light Wings.
Check the performance data from Techpowerup here
EDIT: It performs slightly better, but looks are subjective. Check the review, and similar reviews to determine what fan you like best
Gigabyte 4070 Super Gaming OC.
That is practicly the only one I found that I'd peronally like. Maybe check the 4070 Super offerings yourself. They are pretty good cards and fit your budget
Thats kinda what you get when you want 40mm high RPM high static pressure server fans, they are all going to be loud. But yeah, NF-A4x20-PWM would be my reccomendation too, tough they don't move the same amount of air as the fan you have right now