I don't know if Canon's support site is different from how it was last year, but the scanner driver (in my case the 9950F but also true with the 8400F) is not available when selecting Mac OSX (not OSX 10.6, just OSX). All that was under Mac OSX was the DelDrv file.
Instead, I went to 10.6 and downloaded the Scanner Driver there. It appears that the same .dmg file is offered regardless of which OSX version one selects.
Once I resolved this, the installation worked like a champ. My 9950F is scanning just like it used to.
I have to say, it's really odd that Canon would EOL this scanner for Mac users, but continue to support it on Windows. It obviously works fine and isn't a compatibility issue. It would seem to make more sense to charge owners whatever there margin is on these devices for a software upgrade, and save the manpower/components/shipping/etc. of the new hardware plus the potential annoyed customer, as I for one will never buy a Canon scanner for my Mac again.
Thanks Rabrack a million for figuring this process out.