What are you going to hunt? If it's coyotes, bobcats, and other smaller vermin most anything will do fine. If you are talking hogs, deer, antelope and other deer-sized game I'd suggest Nosler Accubonds, Partitions, or ballistic tips. Hornady factory ammunition hasn't impressed me at all. I have killed 2 antelope with mine. Both were shot with Berger 140 grain VLDs. Both died where they were standing and just fell over stiff-legged. But you may have to search to find that bullet loaded in factory ammunition. I know that HSM loads it and there are probably a few other as well, but I haven't seen it on the shelves locally. Unfortunately that is the only bullet I have hunted with. But I have found that the 130 Accubond also gives amazing accuracy in my rifles with my reloads.
There is a ton of experience on the 6.5 CM at www.65creedmoor.com
You can go there and read what other CM hunters are using and what the results were. The membership there has hunted everything from Alaska large game to prairie dogs.
Welcome to the Creedmoor family. It is my go-to rifle.