I spent years thinking a backless dress meant no bra, full stop, which meant I avoided them completely because I'm not built to go without support for an entire evening. Then I found one with a low cross back and actual stick on cups built into the lining, and the whole category opened up. It was never about bare skin and bravery, it was about the dress being engineered properly for the bit it leaves out.
If you've never owned one, start with a style that has a halter neck or a thicker strap rather than anything spaghetti thin. A halter spreads the weight across your shoulders instead of two thin lines digging in, and it tends to keep the dress sitting still rather than sliding sideways every time you move. Go for a back that dips to the waist rather than right down to the base of the spine too, it photographs just as well and you can still sit in a chair with a proper backrest without wincing.
On colour, plain dark shades are the easiest thing to live with, by far. Black, a deep bottle green, a navy that looks black under lights. They hide the join where the fabric meets your skin, they don't show every little mark from a bag strap or a necklace clasp, and they don't need the exact shade of foundation matched to your back, which is a genuinely annoying thing to have to think about. Pale colours and anything with a shine can look lovely on the hanger and then show every seam and every bit of static the second you're under proper lighting.
The difference between a dress that works all night and one you're adjusting every ten minutes comes down to the back itself. A cheap one gives you a flat strip of fabric and nothing else, so it gapes, it twists, and it shows your bra line whether you like it or not. A well made one has some structure built in along that open edge, a bit of boning or a stiffened panel, so the back actually holds its shape against your spine instead of just hanging there. Check the fastening too. A proper hook and eye or a decent concealed zip sits flat and stays done up, where a flimsy one works loose by the time you've taken your coat off.
Next time you're holding one up, skip the front entirely and look at how the open part of the back is finished first.