Pretty fun, but a bit of a mixed bag. YMMV depending on your table style.
My main disappointment is that a lot of these are "gotcha" items. The PC finds it, thinks its a cool or at least useful item, grabs it, and suffers an ill effect, either immediately or when they try to use it. They then have to deal with the ill effect until they can get the curse removed, which usually takes more than a "remove curse" spell.
I don't find this kind of curse particularly fun, because all you've done, as a DM, is trick a player. Often lethally. Which is incredibly easy to do. If you run the kind of game where schadenfreude defines a lot of the comedy, then the non-cursed players will have a great time with this.
There are a handful of more interesting curses though. Some that a clever PC could even turn into a break-even benefit. And a bunch that are just funny.