Are you planning to use the smart lock as your primary way in, or keeping a regular key option around as backup?
They're genuinely solid these days if you pick a reputable brand - I'd lean toward something like Yale or Level Lock since they've been doing this longer and have better winter performance overall. The battery thing is way overblown, most of them easily last 6-12 months depending on how much you use the keypad versus the physical key. Here's something most people don't think about though: install a weatherproof cover or small awning over the lock if you don't have one already. Moisture and direct rain exposure kills batteries faster than cold alone, and it protects against someone messing with it too.