The comments are funny... I run Home Assistant (using ZigBee, so devices have no Internet connectivity) at home but I also lock pick, for fun.
Sure, your "smart" or "connected" gadgets can be hacked but don't get fooled by believing your "dumb" locks are safe!
As somebody pointed out check the LockPickingLawyer... but if you believe it's complicated buy yourself a lock-picking training kit for 30€. Sure you won't open "fancy" locks easily but you can open a lot of locks by training for like 1h. Get a kit, watch few videos, train while paying attention, repeat while watching a movie (basically blind picking) and you'll get surprised how quickly it comes. If you have very fancy lock (the ones that cost more than 200€) then you need better tooling, like 1000€ automated ones, but that still requires little skill and need a minute to pop a lock (so I heard, this I never tried).
So yes, please, do NOT buy a connected lock if you believe that's unsafe BUT also do not imagine you are safer with a "traditional" cheap one.
PS: full disclosure, I do not have a connected lock but it's not because I think they are more unsafe, just because I didn't bother. I'm not convinced of the utility for the price. That said if you have suggestions, I'm all ears.
PS2: as with similar questions on software, depends on your thread model. If you have to deter playful teenagers or drunkards, sure, it'll hopefully slow them down enough so that they give up. If you are facing professionals it won't matter either way, safer to get insurance for the outcome.