I had these exact concerns after buying a house!
Anything connected to the Internet is inherently vastly less secure. Fortunately, your two usecases can be addressed with a "dumb" keypad lock with two features:
-
Multiple access codes. Set a different code for each trusted party, as well as an extra code that you can give out in case of emergency, which you can reprogram once you return.
-
Automatic locking. Set a timeout for the deadbolt to re-engage after a set period of time. If you forget to lock the door, it simply locks itself.