Please help me understand the drill I should be buying

Looking for a new drill as I burnt out my old one likely pushing it a bit too hard

Rural homestead/farm and all around household needs

Would ideally have enough power to drill 1" holes into logs 6" deep or so, would be nice to have a kit of impact and driver but open to seperate

Trying to stay under $200 Canadian for 1 or $300 for two