For cabinet assembly, the Bosch Flexi-click and the soon to be released Milwaukee installation tool mentioned above would be high on my list. I have the CXS mentioned above and it is fantastic for sneaking into tight spots and it has more power than you would expect for a lightweight drill. The control from the trigger is fantastic if you need to apply a delicate touch to a screw to prevent damage (so far I've yet to find another drill manufacturer that grasps this concept). The downsides are of course price, proprietary battery that is compatible with no other tool, and the centrotec chuck (it has a standard jacobs chuck) which draws you into a line of centrotec accessories that are stupid expensive but really make the drill lighter. Also, not shown in the pic above is the right angle accessory that comes in the full set. I used it recently attaching framing on a deck where space was limited, even for a typical right angle drill.
Edit: One more thing, the CXS also comes with a very functional belt hook, which is something I can't say for many "portable" drill/drivers.
I'll admit my bias here, but I've also owned a Bosch PS21 and 31 and have a current gen Milwaukee M12 hammer drill (as well as an assortment of larger 18V drills). For your typical household tasks or any cabinet construction or cabinet hardware, the CXS is the first drill I reach for. If I need something with more guts, then I'll get it.