I've had a lot of commercial sours...
The sourness level varies but is usually pretty mild for my taste.
Most have fruit but some don't.
Very few are heavily hopped.
The more traditional mixed fermentations product a more complex flavor profile rather than just a clean sourness produced from a faster "kettle sour" method. The fast sour method seems to be way more common unfortunately.
Some of the traditional sours have acetic notes (vinegar).
Some are dry, most are sweet, and too many are overly sweet imo.
Goses have salt. Coriander is common in this style. Other spices are generally pretty rare.
Just reading some comments it sounds like Bell's Larry's Latest Sour is heavily hopped, sweet, and mildly sour without any complexity. Keep an open mind if you don't like that one
Sours are rare so I usually just get whatever I can whenever I can.
Dogfish Head has a SeaQuench ale that's widely distributed, it's a pretty mild generic fast-sour gose with lime.
Lindeman's Kriek (cherry lambic) is widely available -- it's very sweet and very fruity but delicious imo if you don't mind that.
+1 for any Jolly Pumpkin or Duchesse de Bourgogne if you can find them.