An ETA is not required if you drive into Canada, whether you stay overnight or not.
An ETA is required if you are flying into Canada.
Both of the above assumes that you would qualify for ETA entry. If you wouldn't qualify for ETA entry you'd need a Visa.
You do not need ETA for this trip.
The duration of your intended stay in Canada has no bearing on the ETA requirement.
ESTA is a US program. ESTA has no bearing on the ETA requirement or on entering Canada in general.
ETA is required when you fly into Canada. It doesn't matter whether you're staying for an hour, a night, or a month. Similarly, as you ...