The usual mistake is treating a cami dress like a finished outfit the second the weather turns warm, then wondering why it looks like underwear that wandered off. The second mistake is buying it a size down because it's meant to skim, when a cami dress wants to hang, not cling, or every seam shows.
The good ones are cut on the bias, or close to it, so the fabric moves with a bit of weight to it rather than floating up and clinging the second there's a breeze. Pick it up and check the seams at the bust, that's where the cheap ones give themselves away first, puckering after one wash because there's no proper facing behind the straps to take the strain. Straps themselves should be adjustable, not just for fit but because a cami dress that sits an inch too low at the back looks like a mistake rather than a choice. Satin is lovely but unforgiving, it holds a crease and shows every lump underneath, so if you're not wearing something smooth beneath it, a crepe or a slubbed silk type fabric with a bit of texture will hide far more and still catch the light nicely. Hardware matters more here than almost any other dress, because there's so little of it, so a cheap plastic slider on the strap will snap exactly when you need it not to, usually standing up from a chair.
Where it struggles is obvious once you've been caught out by it. Proper cold, it's not happening, no amount of layering makes a bias cut silk dress read as a winter piece, it just reads as a summer dress wearing a jumper under duress. Big chested, you need the fuller cut version with a built in support layer or it'll do nothing for you except show the bra you didn't want to show. And office wear, mostly no, unless the fabric has enough structure to it that it stops looking like nightwear the second you sit down at a desk under strip lighting.
For colour I'd go with something closer to a bunch of ranunculus past its best, a dusty rose, or a deep bottle green, both of those sit beautifully against most skin tones and don't need much else doing to them. A hard, bright white can be gorgeous but shows every mark and every seam of what's underneath, so save it for evenings when you're not sitting on grass. Keep it away from anything with its own strong pattern on top, a cami dress is the quiet part of the outfit, let a cardigan or jacket carry the print instead.
I'd start with the bottle green, every time.