Depends on how many eggs you want and how much noise you can stand. I'm biased because I have muscovies (in LI, NY) after having pekins and cayugas and chickens and I love the muscovies much more as far as ease of care compared to the mallard derivatives, but mostly I love how quiet they are. The pekins and cayugas were set an acre back from my house in their run, but I could still hear them every morning calling for me to feed them through CLOSED windows. My neighbors probably hated me when I had them, even though we're far from each other. Muscovies make pretty much no noise at all. The pekins and cayugas also ate SO MUCH FEED, even if I let them out to forage. If I let the muscovies out, they won't touch the feed at all--they're happy getting most of their diet from the wild things. I find them cleaner too in terms that they really don't bother splashing water around at all even though they have a large bucket as their waterer. The pekins and cayugas made a mess and their run was always sopping wet. I just had them start laying eggs and they taste just like chicken eggs, but jumbo sized. They're supposed to lay 200 a year. The mallard derivatives like the golden 300 layers can lay up to 300 or more eggs a year.
But I have to clip the muscovy wings once/twice a year because they can fly. Catching them and getting thrashed by their sharp talons is not fun (which I learned once and only once), so I really just end up pressing them into the ground once I caught them and clip while I've "mounted" them, so it's not so bad.
Anyway, I find that the pekins had more personality and were more bumbling awkward, so it made them cute and hilarious. My muscovies are just "sweet" but as far as having funny personalities, can't really say they do (but I got them as adults so didn't raise them from ducklings.) But the peace and quiet and the stress of bothering my neighbors more than makes up for it. We used to hide in the house and duck around the kitchen because if those dratted things saw us moving in the house or, god forbid, turn on a light, they'd start setting up a quacking storm. It look a long time for me and my husband to stop ducking around the kitchen window and start using our kitchen light. Must have been PTSD.