Depends on the camera.
With some (or maybe most) Canon DSLR cameras. Full auto (green box) mode gives you the least amount of control. The flash will pop up on it's own, I don't think you can choose to shoot in RAW while in that mode. I don't think you can set the highest ISO either.
Canon calls the 4 primary modes 'Creative modes'...P, Av, Tv & M. P differs from green box in that you can adjust everything else, the camera just gives you the aperture and shutter speed.
I can't remember the last time I used green box mode (if I ever have) and I don't think I've ever used any of the 'picture' modes either. You don't really need to...Av, TV & M can do everything.