I'm 15W / 20L with Sona. In those games I am 129/303/494 with a (K+A)/D of 2. I can usually figure out by the three minute mark how cautious I need to play (have they tried killing me every time I use Q).
Compared to other supports, Sona feels like she does so little to help her ADC since her W is so expensive and will OOM you to uselessness in seconds. Your poke is weak but reliable compared to other supports. Without the follow up AA, Q is not that devastating. Like others have said, she works well with aggressive ADC that gives enough lane pressure for Sona to augment. She can't pressure a lane by herself (well, maybe if the enemy is afraid or passive, she can).
In my experience, Sona is a mid game champ. Once she has rank 3 Q and Sheen (after Sightstone), she can severely punish out of position squishies. I'd say at this point, even if my ADC has been pushed under tower all game, I will start being stupid aggressive because I can chunk an ADC down to half health fast. If the support isn't a tank, I can do the same to them. Sure, the ADC can nearly flat line Sona in the same time frame, but if they go after Sona, her ADC will probably get a double. If they focus her ADC, Sona is quite capable of getting a double on her own. If she opens with her R, she might even get away without taking any damage at all.
I don't think Sona will be very viable at a high level of play. I have never been able to shut down a snowball with her the way I can with Janna or Soraka. I imagine more experienced players would know how easy it is to out trade Sona's early game, pushing back her mid game to the point of irrelevance.
But I don't know why people say the only thing she has is her ult in the late game. A LichBane/DeathCap Sona hitting any squishie with R/Q/AA is instant death. I've knocked a Vayne to 1/4 health without using Sona's ult. ADC don't seem to be in the habit of building MR. I had a game (43 min loss) where Sona was putting out 800 dmg a minute. I can't offer that sort of damage with other supports, mostly because there is so much reliable damage in Sona's kit. The only other "support" that I can think of that could effortlessly match this would be Annie.
And as for Sona mid... I'm a bit too timid to try that out. I'd do a Braum/Sona duo with Yasuo (AD) mid before trying to shoulder the role of APC. Sona feels like such an easy target for ganks and doesn't get any less squishy in a 1v1 against a standard mid laner.