I have a rack of handpieces, but us the standard H30 for 99% of all tasks. It holds any size burr or drill you would need in a handpiece. For some tasks, I use an H20, which is a quick-change handpiece that takes 3/32 bits. Both are beefy enough to take some abuse, and comfortable in the hand.
What I would recommend as even more important than the choice of handpiece is the choice of cutting bits and burrs. Get carbide whenever possible. The price may seem high, but they last almost forever with proper use. The cheap "Hobby burrs" are just a waste of money. Busch and similar burrs are worth the price. Lastly, trying to make a dull bit do work is like trying to make a dull drill bit drill a hole. It won't work better by pushing harder, and it will harden the steel. When a burr gets worn......change it and throw the worn on away.