I use Milwaukee fuel 18v hammer drill in conjunction with the Milwaukee fuel 18v hole hawg on the job site. The Milwaukee big hawg bits work great for rough cutting joists and studs. I mean rough cutting because if you are looking for a real clean cut use a hole saw bit because the arbor on the big hawgs walk a little till they seat in the hole. When drilling cabinets I use my spade bits or hole saws. I used to use auger bits, self feed bits back in the days, but you just can't beat the stuff that is out today and they do not beat up your equipment like the old school bits.
I would imagine a pdc would get the job done too with the 90 degree angle chuck, in just about any situation, but I can't imagine spending big money on that drill when you can get the tools complete listed above for the cost of a pdc alone. I have beat the snot out of my 18v fuel it just keeps going. I have picked up back up bare drills brand new n eBay for $89.00 and have not needed one yet to replace mine
I love festool drills for my woodworking I have a csx and a t15.