Is anything lost when you export from (Canon) RAW files to TIFF?
For context: I backup and archive my RAW files, and keep a separate (Aperture) library for exported JPEGs. So far my workflow has been in Aperture (edit the RAW, export to JPEG), and that's fine.
However, I really like what the DxO Optics Pro software does (where it improves sharpness, distortions and CAs on a lens by lens basis), but obviously you can't export a RAW file into Aperture. It needs to work on the RAW, so it's adding a step to the process, as it doesn't have the library or editing features of Aperture
I tried the DNG format, but get files sizes over 150MB! (Compared to 25MB RAWs)
It seems that TIFF is the best option, but will I loose things such as the ability to bump the exposure 2 or 3 stops? (More applicable to highlights/shadows, but I assume that's the same principle.)
Are there any other more subtle things I would loose for editing?
Provided the TIFF is 16 bits then you wont lose much editing latitude compared to the RAW file. What you want to do in DxO pro is develop the RAW for further editing, by reducing contrast to ensure that neither highlights or shadows are clipped. If you do it right the image should look really dull. Don't worry though - you'll be viewing the image on an 8bit device, there will be plenty of detail there to be developed when you finally process the image in lightroom.
You want to also aim for a neutral colour balance in DxO to avoid clipping any colour channels, giving yourself the maximum tonal range possible. Obviously having DxO sharpen you images will limit your editing options with regards to sharpening / noise reduction.
By exporting to TIFF (and any other format using RGB pixels) you lose the ability to use different demosaicing algorithms. Demosaicing influences noise reduction, picture sharpness and false color (moire) reduction.
The future color and exposure manipulation is not affected (assuming sufficient bit depth - 16 bit TIFF).