So one time I unlocked my mom’s car with the remote from inside the house. I took a little while to leave though and the car has an automatic thing where it automatically locks again if left for a few minutes.
When I finally got to the car and pulled the door open, the relock triggered literally as I was halfway through opening the door. So it was kept half closed. Kinda like when you close it but don’t put enough force into it? Hard to explain. Anyway I felt like I was being pranked.
You can turn it off in every car I’ve ever used. I guess making it default is questionable, but modern cars make it painfully difficult to lock yourself out so it makes sense imnho.