In my experience, CCSG does a great job in most instances, it is kind of industry standard not for nothing.
When reproducing paintings, if it is possible to work with patch sets made from actual painting pigments, I'd recommend doing so. The team of basICColor would support you in getting the patch set into input 6, AFAIK. In this video from Chris Campbell you find valuable input on those topics: