One *cannot* use HCC for transactions. No row locking and modify DML requires CU decompression. I wrote about this in Expert Oracle Exadata (Apress).
HCC is, generally speaking, a reasonable archival solution...and there are certainly other products in that space.
Alsways remember the truth about HCC compression ratios as well: