SQL Server 2016 - ColumnStore Clustered Index vs. Non-ColumnStore Clustered Index
Clustered Columnstore Indexes are designed to be used primarily with Data Warehouse, OLAP or reporting solutions.  They are not great at WHERE x = y type queries; they are excellent at WHERE x &lt; 1 and x &gt; 1000000 type queries where the query processor can perform a range-scan on the CCI.

Assuming your workload is OLTP-critical, I'd recommend, without a ton of work on my part, to create the table with a standard B-Tree clustered index, and consider a well-designed nonclustered columnstore index that will help with your point #2.

If the OLTP component of the workload is small, or not very critical, but the reporting component is critical, you could possibly create the table as a clustered columnstore index, then add a number of starndard b-tree nonclustered indexes to help support the OLTP component.