I find that if the enemy has no culture, or very weak culture, the Advent cannon can wreak some real havoc. However, if the enemy has strong culture coverage and it is teched up, the cannon's culture effects are minor and are rapidly shrugged off....even when you fire a few at one time. It does cause some economic impact and convey a culture bonus to you in that gravwell for a brief time, but against strong culture the effect is so small that I am not sure it is worth building a chain of cannons.
Considering the amount of havoc or economic impact you can cause with 2-3 TEC or Vasari superweapons, the Advent cannon seems a bit weak. Of course, everything else about Advent kicks butt, so I'm not ready to cry for them just yet!!!