Would love to see more information about each of the ALTER DATABASE parameters... a specific... "connlimit"... -1 means no connections, but what does 0 mean? Are there users that connect even though the connection limit is exceeded. Is there special allowances for other database connections, ie backups?
I would expect superuser roles to ignore all of those options. Everyone else, not so much. connlimit=0 should have the same effect as allowcon=false
There is some enhancement at the margins here but unless you are trying to do unusual stuff it should be working as one would intuitively expect.