There are other alternatives for sure... like "Cougar" which is another one I have and it's a good fan with efficient air flow. Also what do you mean by there will be any compromises?
To choose the best Fan you've got to make some comparisons and see reviews regarding it's resistance and reliability. It differs from each persons perspective and for what goal you may want to achieve, for example in your case you said yourself you are a "casual gamer" so I guess any Corsair, or any matchable fan with similar aspects would be good enough for you, it also depends on some many other things like - Environmental conditions, the place where you play, the place you live, the size of your case, cable management they will all impact on your case air flow, so you can't just rely on a fan potencial only. As for dba, any quiet edition should be good enough for you, watch some reviews regarding the noise levels of each fan that you may find it good to afford. I myself would preferably go with a quiet one just like I did with both Corsair and Cougar fan. I can't hear any noise but the natural air flow going in and out the case, but only if I get my ear close enough to listen to it... otherwise everything remains silent, the same goes for the Cougar fan. As for CFM, fans with higher CFM tend to be more efficient hence it may become more noisy sometimes, but I wouldn't mind much about it since most of quality fans are compatible with fan controllers if you have one.. that will allow you to adjust the fan speed according to your needs. But mostly for games people don't usually touch that much not that I'm aware off. Also in all my experience with computers, I had only one cheap crappy fan that died on me all the rest that was pretty crap too, did the job for both gaming and normal tasks.