Dark Harvest is overtuned but its not an auto pick
It's very snowbally but it won't reward you if you're getting zoned or dying. Its best for Assassin/Fighter style champs since they can dive champs who are low hp with less risk, but Sona is one of the squishiest champs in the game. Even if an auto is all you need to proc it, its at best situational. You're better off with Aery for poke, Spellbook for versatility, or Klepto if you're greedy. Dark Harvest will net you more damage over the course of the whole game but only if you're ahead.
If you're playing something like Sona/Lucian or Sona/Draven into an easy matchup, Dark Harvest will probably work just fine. But don't treat it like a free win, you have to earn those stacks.