OK so to get infinite health - Godmode you don't use a cheat pkg. You edit the games memory in real time so if the console turns off then so does the godmode. If you use a modded eboot these mods are in the games files and so even if u turn off they're still there. By connecting your CFW to your OFW, people data transfer patches, these are older methods of modding, such as an MW2 patch. Also by data transferring you can send any downloaded map packs or dlc to your OFW and play without a a ban worry.
Any cheats added to the games files will not be transferred as the Eboot will not load on ofw. Patch_mp.ff on the other hand may load but not always.
In conclusion (damn this was an essay) there is no reason to connect your ps3s together as the hacks will not transfer, but if you want to add your illegally downloaded dlc to play online with, TLOU for example; then connect them.
Hope I helped
xShaTTer