The first question I would have in upgrading to custom firmware is
1. what effect it will have on my library of games in digital form from psn as they stand, and/or any downloaded updates or other digital content.....
2. is there any drawback or file error concerns (even with retail games), or games that might not play properly or anything such as reconnecting to psn to activate downloaded content etc (such as what happens if you loose the cmos battery).
1. No effect unless once on CFW you decide to customise the system further with IDPS spoofing in which case you would need to create/install a new rif license file for each PSN game that needs one.
Keeping in mind that with CFW you can backup, restore & tweak any PSN game & its license.
2. Although it is the exception rather than the rule, there can be specific settings for a handful of specific games depending on the method chosen to mount them (Legacy JB folder format, BD Emulation etc..) as well as the CFW setup (Rebug specificities, CEX, DEX etc..).
As a rule of thumb on CFW, disc based retail PS3 games should keep working the same way as on OFW, same thing goes for PSN games.
As to PS3 game backups, if you are using ISO format for games on a full CEX CFW like Evilnat's Cobra CFW, no tweaks or special settings should be necessary.
Generally speaking, having CFW will make any future problem easier to sort out. Moreover, nowadays it is extremely easy to switch between OFW & CFW, you no longer need hardware flashers, so if you needed to connect to PSN to reactivate your system or whatever & really didn't want to take the risk to do it while on CFW, you can always install OFW, do your stuff, then jailbreak & reinstall CFW.