CSO is a compressed version of the ISO format. You can save a few extra megabytes (game dependent) by using this format BUT it will increase loading times and possibly stutter any FMVs in the disc.
Best option is to use it for games with no FMVs and simple load per level systems. RB: Unplugged is the only CSO I use. Any other one I've tried hasn't seen much size benefit.