Depends, body odor comes in a lot of "flavors" just like any other smells do. Someone who sweats a lot because they're 400+ pounds but is generally-cleanly otherwise (i.e. bathes often and thoroughly, uses deodorant, generally maintains "normal" hygiene) is gonna smell pretty different from someone who sweats the exact same amount but has abysmal hygiene. Likewise, if someone hardly sweats at all regardless of weight due to genetics and/or local climate, that's also gonna have an effect on how much they stink and how it actually smells.
Whether or not the smell of either extreme or anything in-between matters to you is a matter of personal taste, at least in private, but you can't exactly be shocked if your morbidly-obese or larger partner waddles past a stranger and gags them out with the smell of unwashed ass crack and fat folds. If you want them to be a unwashed lard-ball that stinks like the dumpster behind a chinese restaurant after a hobo pissed in it, and they're also into it, then by all means that's your shared right as sapient beings with kinks, but you should probably wash up temporarily if you're gonna dress up and go out for an occasional nice dinner, is all I'm saying.
For me personally, lots of sweat and natural body odor but minimal bacterial-stank is where it's at. I'm all for natural body odor, but not a fan of the reek that comes with being outright-filthy and having bacterial buildup that causes the really nasty smells, especially anything involving bodily waste.