I work in construction so have gone through my fair share of drivers… teal, red, yellow… lots of brands vintages and models. One I will say avoid are the Milwaukee small drivers. They have poor low throttle control and I find myself getting frustrated with that often (like every 5 screws the motor stalls). The cheaper homeowner variety will have the same issues (Ryobi, hf, etc). My favorite and daily driver are my Makita LXT brushless drill/drivers with 5.0Ah packs. Those are bulletproof and a joy to work with. Setting counter sinks they have IMHO the best control available. In fact I still use my 15yo driver all the time (this has included many times where it was used to zip in self drilling screws in thick steel for 8hr shifts… won’t overheat on you). Yellow are decent too, but a bit heavier in the hand at the end of a long day, and a tad less finess with countersink vs makita. Before buying any drill, I suggest picking one up and driving some long screws with it (not just one screw… like 20 to give it a chance to f up if it is going to)… see how they feel because tools with annoying habits are no fun to live with.
I won’t get into battery ecosystems, since you are just asking about a driver not tools for construction. However if you are planning to add tools to the batteries, this is something you absolutely have to think about. At the end of the day you will be married to the batteries, not necessarily the tools. So don’t make a bad choice there.this is where the spendy brands are better.
I personally use my tools way too often to get hf or Ryobi. The homeowner brands end up costing you more long term if you are like me.