For FEI classes you're required to use a double bridle which is PSG, Intermediare 1, Intermediare 2, and GP. However you can show above PSG and all the way to GP in a snaffle for USDF/USEF classes. One of my trainers showed GP in a snaffle.
Also most well trained FEI horses school in either a snaffle or a double. They should be able to school in a snaffle. The curb does not create collection. The curb however does help with elevation and softness. If you have a horse that is very strong in the bridle and some are, even if they've been well trained. It helps lighten them off the bit and help them back off the bit. Some of the strong, heavy warmbloods are like that. It also can help with elevation but should not be the source of it.
The reason a double is used rather than a snaffle is partially tradition and partially for refinement. It is a skill to use the double bridle correctly. The double bridle is a tool, nothing more, nothing less. It can be used well and improve the horse's way of going or used appropriately or it can be abused. Just like any other tool. It's dependent on who is using it.
I know for my barn we introduce the double bridle at 3rd level. It doesn't mean we always ride in one but we introduce it to the horse and rider to use it. We usually introduce it for the first few rides with the curb rein loose and use the snaffle while the horse gets used to the two bits and gradually incorporate it, so they can get used to it.