The languages are, I guess, most useful for people who design their database as a datastore with an API, used by multiple independent clients (a common setup in enterprises). The API typically consists of stored procedures, and normal queries are disallowed for most usernames.

Being able to implement such an API in $DECENT_LANGUAGE and not pl/pgsql sounds like an enormous win.