How often do you change your golf ball?

You know I have been playing for a while and I am honestly chasing the perfect ball for me. I have more golf balls then I will ever need but the fact that I cant find the one that does what I want or expect at times.

soft feel great but does not carry at times so I hit harder and end up in the weeds.
Firm jults me but flies like a tornado.

Im not sure where I need to go from this.