I know Agitha can be effective, I just can't get over her standard attack range and boring combos.
Her, Cia, Zelda, Lana and Wizzro are all characters that I avoid because I really dislike their movesets.
I really enjoy all of Zelda's movesets, the rapier especially but the other 2 both feel very fun to use.
The rapier allows for insane control, you can literally turn and move in any direction during any part of her combos, you can alter her combos to your choosing by deciding to use the light orbs or not and she has amazing options either way, with the only really bad move being her C2.
Breaking through weak point gauges is super easy due to the multiple hits on her strikes and she gets close really easily with her standard attack string so she is pretty insane at fighting one on one.
The Wind Waker has some amazing coverage moves that are incredibly satisfying to use, you just have to know how to position her correctly as she doesn't move during her combos like most characters.
And her dominion rod is pretty much the same.
Cia is also a great character, she is solid for taking down mobs of enemies, fighting one on one and breaking weak point gauges and for defeating giant bosses.
Lana And Wizzro are hit and miss but do have their strengths, for example Wizzro is also incredibly good against giant bosses and Lana's summoning gate has one of the best moves in the game