An upholstered bed makes the most sense if your bedroom doubles as somewhere you actually spend time, reading, working from a laptop propped on your knees, having coffee before you're properly awake. The soft headboard is the whole point, something to lean against that isn't cold wood or, worse, nothing at all. If you've got a bedroom that's purely for sleeping and you're never in there during daylight hours, you might not get the full value out of one, and if you've got pets who treat furniture as a scratching post or kids who use the headboard as a trampoline backstop, go in with your eyes open about what fabric can handle.
Where these really come into their own is in rooms that get decent natural light in the morning, since that's when you notice the texture most, a linen or boucle headboard catching low sun looks completely different from the same bed under lamplight at ten at night. They suit bedrooms in older houses with a bit of character just as well as a plain rental box, maybe better, because the bed adds softness a rental often lacks. Colder months are when they really prove themselves, a fabric headboard just feels warmer to be near than a slab of veneer, and in summer a lighter weave keeps the whole thing from feeling heavy. On finishes, I'd steer toward mid tones and neutrals, oatmeal, a soft clay, a grayish green, something that doesn't show every mark and doesn't date the way a very trendy color will in three years. Pure white looks great in photos and shows everything within a month, a glass of water, a greasy hand, a curious cat. Deep charcoal or navy hide more but can make a smaller room feel like it's closing in at night if there isn't enough light bouncing around.
In an ordinary room, these sit well with simple bedding rather than busy patterns, since the headboard is already doing visual work. A low bench or a stack of cushions at the foot, a couple of plain lamps, a rug that doesn't compete, that's really all it needs. Skip piling on more pattern right next to it or the whole corner starts to look like it's trying too hard.
Over time the fabric softens and loses that just unwrapped stiffness, which I think is an improvement, it starts to look lived in rather than staged. Lighter shades will pick up the odd mark no matter how careful you are, but a bed that looks a little worn at the edges after a few years of actual use beats one that still looks like a showroom and feels that way too.