I have a 226 357/.40, had a Pro CDP; totally different animals. Are you a cocked & locked SA type, or do you prefer a decocker DA/SA? Different operation, different ergonomics. It an old refrain, but test them and see which fits you best.
Re my experience, I'll never buy a souped-up 1911 like a CDP again. If I had to do it over, I'd get a stock Pro and add some new sights. The CDP is not even close to being worth the extra $$ in my experience. Seriously crappy night sights that had to be replaced after 400 rds, an internal burr on the trigger that prevented it from being fully pressed (and hence firing) abt 1/4 the time, innacurate, very fussy on ammo, etc. Got it all fixed up at the factory so it worked fine, but I never got mentally comfortable with it. My full size Kimber is a different story - never a problem, exceptional accuracy.
The 226 has also been unfailingly reliable, and is very accurate (esp. in .357 SIG, the chambering I purchased it in). SIGs have a long trigger reset, which some people find tough to adjust to, but it's smooth both DA and SA. I like the 226 grip much better than a stock 1911, which is too small and esp. way too skinny for me. I have to oversize mine w/aftermarket grips. If you're thinking potential concealment, check out a 229. More similar in size to an Officer's 1911 like the Pro and more easily concealed.
Good luck.