Electric door lock with status monitoring and traditional key

Hello, I am looking for a door lock that allows the door to be opened and closed electrically (along with status control).
This could be implemented via relays, could be controlled via Arduino / Raspberry Pi etc.
The key thing for me is to be able to operate the lock also with a traditional key.
Ideally, it should be a lock like this one:
Instructions for posting pictures and images on the forum https://www.elektroda.pl/rtvforum/topic2053101.html [retrofood]

I've searched quite a lot on the web, but most are whole solutions, like locks with RfID (these in turn are hard to open with a key) or combination locks.
I only need the lock itself (lock), which I can control myself.

Mate, you won't find anything more simple and effective than an electric door opener or electric door strike. You control these devices with or without 12V so what is the problem with using RSP/Arduino.

The solutions you have given are certainly simple, but effective in my case I wouldn't call them.

First of all - I would like such a lock on the entrance door to the flat, so it must be possible to leave the door open, so electric strikes are out.

Unfortunately fellow akla you need to decide what you want?
If you want remote and manual access to the door then you need to decide what is the priority i.e. if you want to be able to remotely open the door when it is locked and what if you remotely open and manually want to close it?
There is no easy way to reconcile remote and manual opening and closing at the same time....

Link

And something like this?