I know it's a fan favorite here on the boards, but I don't see the appeal either. Very frumpy. I highly prefer its other forms, like Margery or Margalit.
I prefer Marjorie or Margot/Margo to Margaret. Those sound like fun, while Margaret sounds like she would whack you on the hand with a ruler for having fun.