For me the best ratchet is a long handled flex head snap on 3/8", but I use it everyday to make a living.
Long handled flex head will do most of what you ever need to do with a ratchet, but there are certainly times when it won't work.
A stubby flex head 3/8" is probably my second most used ratchet, followed by 1/4" long handled flex, and then a 1/2" long handled flex.
Also worth noting is I will use air by preference, so that will switch things around somewhat if you don't have it handy. Still mainly the 3/8" long flex head, but the 1/2" would get used more for sure.
There are also times when a straight non flex ratchet is handy, especially using universal sockets. Pretty much guaranteed to pinch your hand if you use a universal socket on a flex head.
Anyway, given your situation I would say the best for you would be the gearwrench set of 4 ratchets.
https://www.amazon.com/dp/B000V5G7LU/?tag=atomicindus08-20
For about $100 you get the 4 most common ratchets (somebody did their research well), easy to warranty - at least in the US, and fairly decent quality, and they have a fairly stiff/incremental flex so will kind of work as a straight ratchet also.
Advance/discount carries gearwrench and if you buy any parts there - odds are you will, they will warranty them no problem for sure, and probably even if you don't buy anything there.
Several guys who have passed through our shop have had these sets and they seem to hold up ok.