There's an advantage in having commonality of batteries to more demanding tools but, especially if you're buying at the cheap end of the market where tools tend to come with their own bespoke batteries, a
3-cell pack isn't expensive and there's a lot to be said for just keeping a 10.8v/12v drill/driver, especially if you're just drill/screwing into wood, assembling flat-pack furniture and the like.If you're doing heavy masonry drilling I'd guess a bit more power would be useful - I used to have a mains drill where my 14.4V (4 cell) Aldi drill wouldn't cope, but nowadays I just use an 18V (5S 2P) cordless.
Another use case of a 12v is a cordless ratchet for working on cars, where the small size of the tool allows you to get into tight spaces.
Theo