Optimise for Analytics configuration option
Would love to have a new Server-Wide as well as the Database Scoped Configuration configuration that would be called "Optimise for Analytics" and that would server the purpose of tuning the Storage Engine & Query Processor specifically for the Analytical Workloads (Business Intelligence, Data Warehousing, Data Preparation for ML, etc).
The actual functionalities to be controlled by this option would be such as: -E configuration, Query Optimiser huge preference for the Hash Joins, Bigger preference for the Batch Execution Mode for the Rowstore tables, Bigger preferences for the Scans and Prefetching for the Storage Engine, Bigger Columnstore Object Pool allocation for the server, Actual Cached Plans improvements, etc
Tunable is a good idea for your requirements.
P.S. It's usually optimizer, not optimizer.
Niko Neugebauer commented
More details on the suggestion can be found at my blog - http://www.nikoport.com/2019/01/05/optimise-for-analytics-should-be-a-database-configuration-option/