What fan curve options are you looking for? It's just a fan curve. For me I just set a typical fan curve that was a little more aggressive on the top end. But I guess one option would be to use software to get your optimal fan curve then just use that data in BIOS.
For me, less software, less processes, less CPU usage is the benefit.
One thing to note, when I ran the Optimize All option the fan curve it recommended was almost spot on to the one I was using.
AMD 3070x paired with ASUS ROG 360 with 6 fans (push/pull)
Prime95 for over an hour, I never go above 74 degrees and all cores hit max.
Nothing I do will ever push my system harder than that. Getting a little off topic now but the take away is my Zenith II Extreme even when pushed super hard is pretty quiet. And of course stay away from the ASUS AI software garbage.