I have yet to see any improvement on paper or in performance when using a small primer in the Creedmoor. Unless you have a firing pin bushed or a custom action plan on using CCI #450's or you will have pierced primer problems. I much rather use the large rifle primers and avoid the hassle of changing out components in my priming press and reloading dies to handle the small primer.
That's why I've opted for 260 Rem in my FN SPR now on its second 6.5 rebarrel. SP primed brass was hopeless in this (Winchester 70 pre-64 type) action with blanking at very low loads. A bushing job is £300 ($380 US) in the UK which is just too expensive when there are LR alternatives. But if I have to use LRP brass, I'll stick to the higher case capacity 260 and run it long-throated to get bullets in the right place rather than move to the Creedmoor.
Having said that, my experience with early Hornady 6.5 Creedmoor brass was that its case-head construction is in no respect capable of delivering the cartridge's rated 62,000 psi SAAMI pressure - well, not for more than two loadings at best! In practice, both factory ammunition and handloading data appear to run at 57-58,000 psi, in other words no advance on the quarter century old 260 (half century really with the 260's various 6.5-08 wildcat antecedents). With SP Lapua brass, people I compete against are producing some impressive MVs from the Creedmoors (6mm and 6.5mm) in suitably chambered 28-30 inch barrels and giving impressive precision too. The brass takes what must be very high pressures without complaint ........ but the barrel throats less so. (Shades of going round in circles and returning to the 6.5-284 with its barrel hungry habits!)