Probably not as a GUC (configuration option, like in PostgreSQL.conf). There's a somewhat established principle that GUCs should not change query semantics.
Personally I can see such an option being ok as an initdb-time setting or at CREATE DATABASE time. Case folding can know the current db from global context.
It'd have to be fast though. Very fast.
