*) but there are probably equally who prefer to handle business logics outside the database
It is maybe main difference between me and you. Usually I don't write CRUD applications, and I am not sure if plpgsql is good for CRUD.
Mainly I would not to optimize plpgsql primary for CRUD.
I don't think providing syntax to support the CRUD-like use case would be "optimizing it primarily for CRUD". Changing how UPDATE and DELETE work by default would be, but that's not being suggested here (anymore).
I am strong in opinion so safe stored procedures should be verbose. It is in contradiction to Joel direction.
I wrote a proposal, how to do more friendly but still enough verbose