Default cache configurations for local/passivating caches are overly restrictive

For local caches with either a passivating, non-shared cache store; or without a cache store, the use of transactions overly restricts concurrency and limits performance.