For a professional, a cordless drill is a no-brainer. You're frequently away from a power source, moving around all the time, using it frequently enough that keeping it charged isn't a concern, and using it so hard that it will likely burn out and require replacement before the battery dies and the product line becomes obsolete and they don't sell batteries any more. And you can write off the purchase as a business expense.
For all these same reasons, a cordless drill doesn't make sense for a homeowner, in my opinion. You'll be using it in and around the house nearly all the time, with ample access to power. The infrequency of use will mean that unless you keep the battery constantly charging, it'll be out of power when you need to use it. And since you'll probably want to keep it for 10 years or more, it will be a major hassle when they stop making the batteries in 5. A corded drill is also cheaper than a cordless drill. Typical homeowner use will not destroy even the cheapest drill.