The row-level locking and SKIP LOCKED seem like appropriate features for a SQL-based DBMS. I find it odd that it's not more common, actually. Even MSSQL doesn't make any promises about locking just a row and might decide to lock a whole page instead, from what I read anyway.
NOTIFY/LISTEN might be scope creep though. I'm not really sure what led to it being implemented.
AI is used to various extents:
For a file manager, I would be careful how much I trust AI output.