Sequin dresses used to mean one stiff, scratchy shape that turned up every December and sat under a layer of tinsel-adjacent static. That has genuinely changed. The fabric behind the sequins is softer now, the sequins themselves are smaller and lie flatter, and the shapes have widened out well beyond the one bandage cut everyone used to be handed. It is a better category than it was, and most of that is down to what is underneath the shine rather than the shine itself.
If you own none, start with a plain shape in a dark colour, bottle green or black rather than silver or gold, with sleeves or at least a proper strap, because the thinnest straps are usually the first thing to slip and you do not want to be hoisting a dress up all night. A slip style with weight to the fabric will sit better across the stomach than anything clingy and unlined. Over months, the thing to watch is the lining and the thread holding the sequins on, because a dress worn two or three times a year for several years will shed a handful of sequins no matter what, that is normal, but a well made one sheds from the edges and seams, not in a patch across the front. Keep it on a padded hanger rather than folded in a drawer, because folding creases the backing fabric under the sequins and that crease does not always drop out. Hand wash or a proper dry clean only, never a hot wash, and never tumble dry, the heat warps the backing and the sequins can melt slightly at the edges and go dull. For ordinary wardrobe pairing, a sequin dress does most of its work with plain, unfussy layers around it, a soft coat rather than a puffer, a plain clutch, shoes without their own decoration, because the dress is already doing the talking and anything else sparkly on top just looks busy. Tights in a near skin tone or opaque black keep it from tipping into fancy dress.
The difference between a good one and a disappointing one is mostly in the hand feel and the finish at the seams. Pick it up and run a hand across it, a good sequin dress feels smooth with give, not like cardboard, and the sequins should overlap neatly in one direction so they catch light evenly rather than sitting in patches at odd angles. Check the inside seams for loose threads and check the zip, a cheap zip on a heavy sequinned fabric will catch and strain within a few wears. A lined dress that sits well on the hips without gaping at the back zip is worth more than one with a flashier print of sequins and no structure underneath.
Reach for it whenever the occasion is dressed up enough that plain fabric would feel like an afterthought, and nothing else in the room is going to do the shining for you.