The differences are pretty simple:
The Super uses a round actuator, and switches with blades on them. This allows for adjustment of the size of the dead-zone, diagonal actuation zones, and actuation sensitivity. All three are affected simultaneously, so striking a balance between the three is necessary. The actuators can also be flipped, to alter the range of adjustments possible. Stock units are available only in a black bat. There is also a leaf switch version available.
The Competition uses a square actuator, and blade-less switches. There is no adjustment capability. However, they are designed to be stronger in the cardinal directions, and less sensitive in the diagonals. They are usually a good choice for the basic panel, expected to play 8-way, as well as 4-way games, reasonably well. Their "out of the box" lower sensitivity in the diagonal zones, with the ability to still achieve them when desired, is what makes them attractive for multiple game type use. They also come in colors.
Spring tension, durability, mounting methods and general feel, are on par with one another.