My wife has SRAM red on her Orbea Orca and loves it. We made the conversion from a D/A triple to SRAM when she got the Quarq power meter which was on a SRAM 900 crank and she wanted to convert from a triple to a double.

I believe that most pro teams that use Red buy a Force front derailleur with the idea that the titanium Red front der is not strong enough and the weight difference is not worth the possible lost reliability. However, that is old data and possibly the new Red front der is improved.

SRAM Red, and I am not sure about other SRAM offerings, offers adjustable reach on the brakes. For women with smaller hands this is an advantage and the hood design fits her hands better. The brakes work really well not that D/A or Ultegra do not.

The SRAM double tap takes some getting used to. At first, she would overshoot moving the chain to a larger rear gear than she wanted or conversely shift to a smaller rear gear when she wanted an easier gear. Those problems are gone in a few rides. Also, the double tap shifting is easier for women with smaller hands and it takes a lot less force to shift the front der.

THe Red has ceramic bearing in the bottom bracket and in the rear der pulleys. The mechanic on the women's pro team Team Tibco told me he changed the regular bottom bracket bearings on the team bikes to ceramic without telling the women. They all asked him what they did to the bikes that made them faster. Ceramic bottom bracket bearing and in general ceramic bearings make a noticeable difference.

Some people like the Red cassette and some do not. The SRAM drive train with a SRAM chain and red cassette can be noisy. We use the D/A chain and it seems normal to me. The rear red cassette being a solid steel body make a different sound when you change gears than Shimano.

SRAM red used to be the lightest gruppo but Campy may have a slightly lighter version. IMHO, you will not notice much change with respect to weight going from Ultegra to SRAM Red. It will be lighter but that will only add value climbing and the energy saving small. However, lighter, that is reliable, is better.

My wife likes the look and feel of the gruppo and likes it better than D/A. She really likes the Quarq power meter which has made a significant change in the way she trains and has improved her performance dramatically. But it was all good.