I switched my front door over to a Yale smart lock a couple years back and it's been solid through some pretty brutal winters here, so I'd say they're worth it if you go with something established.
The battery thing isn't as annoying as people make it sound - mine goes through a set of AAs maybe every 8-10 months, which is way less frequent than I expected.
My main tip would be to actually test it in your specific setup before committing, especially if you have a garage door since those can have weird interference issues. Are you planning to use it mostly for convenience or for actual security reasons like monitoring access, because that changes what features you'd actually use?