In TNG, I hated the Ferenghi though to be fair, they were being fleshed out and explored in that show so mistakes were obviously going to be made. They're clearly wanted them to be serious villains but that was never going to work and looked ridiculous and they quickly realised that they were too laughable for that. So how about comedy?
Well I still disliked them as comedy characters too and one of the things that put me off DS9 was the fact that the show had a Ferenghi as a regular character
First time round, I still didn't care for the Ferenghi episodes but with each new viewing, I enjoyed Quark more and more and a few years later, I finally saw how good that character was and how well DS9 presented Ferenghi culture.
Shimerman takes most of the credit for changing my mind
Little Green Men is a favourite