If you want to blow a hole in a wall, or if you want to break things like trees (aka Crysis) or if you want to create "on-the-fly" props from the engine, you absolutely need CSG.
Crysis does not use CSG at all. All those breakable items are pre-made to break at specific points.