[M]y gear is ... imageprograf pro 1000.... I typically print via photoshop's canon Print Studio Pro plugin .... However I do a bit of correction and processing via DXO Optics Pro and that software does not support the canon plugin. It does give me an option of using the paper ICC profiles in the print settings but compared to the output from Print Studio Pro, the color is way off. DXO Optics Pro printer setting does give me the following warning "Don't forget to turn OFF color management in the "printer Properties" window and I am not sure if this applies to the Canon driver?
This may well be an Apple / Windows issue, but what Panagiotis said is exactly how it works for me in Windows 7 with a Pro-100 (not Pro-1000). But there may be another workaround too: DxO Optics Pro has a plugin that works at least with Lightroom. I don't know whether it works with regular Photoshop. You do have to choose to install the plugin when you install (or update) Optics Pro; however, IIRC it detects that I have Lightroom and suggests installing the plugin.
More generally, as much as I like DxO Optics Pro, printing is one of the two big issues that IMO DxO should address, at least by version 12 (currently I've got 11.4.2 Elite, and I've been using it since version 8 or 9):
(1) the internal working color space should be expanded from Adobe RGB to ProPhoto RGB or some other wider-gamut space, and
(2) the print section needs a substantial improvement, because the current options and controls are somewhat limited and crude.