I got the CamCon last year on eBay for a very good price. As soon as I saw it for $225, I knew I'd have to buy it
You'd get minor gains without the wideband, as PowerEnterprises provides default VVT-i settings which are supposed to be an improvement over stock. Those settings probably then need tuned further, but you really can't do that without repeated runs on a dynamometer. With the wideband, you'd be able to further tune your engine as you added new mods. I really don't know what a SAFC is, nor how you'd be able to use it without tuning it, other than it has a map it ships with that is pre-tuned to overcome known shortcomings in the specific honda engine it is being installed into.
A wideband can be sorta a pain to install, the guy who I had mount my bung on my stock header really scratched everything to hell while taking it out. I took that header off a few days later and it came out effortlessly if you took the shields off first. It pays to find a good shop (which I haven't yet, after all these years of visiting garages...)
The people running the 05 Corollas are using eManage (I believe) because the supplied TRD engine management needs to tie into the stock ECU, which has changed pinouts from 03/04 to 05+
The CamCon should provide gains on any engine, but the factory supplied VVT-i settings may no longer be ideal, the unit would need retuned. The very quick and easy access to the rough WOT AFR tuning capabilities is pretty nice too. Not worthless, but not a wildly compelling device either.
No idea about the SAFC. I never see substantial mention of it at any of the forums I read, but each group seems to have their own preferences. You'd have to just take a look at what it does, in general most import engines function the same, and engine management that works on one typically works on another...I think...
I don't think the fluid ends up being the weak link, from what I've read there are softer bits inside both the automatic and manual transmissions that are likely to fail as the HP increases. However, at the modest 175HP you might be making, transmission failure shouldn't be a problem. Just make sure to increase your fluid change interval. Auto tranny fluid should probably be changed every 20-30k, especially if you drive spirited. Grandma might be able to get away with 60-90k intervals, but I wouldn't.