A modern bed, clean lines, low profile, no fussy carving anywhere, suits a room that already knows what it's doing. If your bedroom is mostly calm, a few pieces, decent light, this kind of frame looks deliberate. If your room is already busy, a lot of pattern, inherited furniture, a rug you love that has four colors fighting each other, a stark modern frame can look like it wandered in from a showroom and got lost. Kindly, if that's you, a simpler job might sit easier than the starkest option on the floor.
Before anything else, measure the room, not just the mattress size. Modern frames often run low to the ground and wide at the base, some have a platform lip that sticks out past where a headboard would normally end, and that extra few inches matters in a smaller room where you walk around three sides of the bed every day. Stand where the bed will go, use tape on the floor if you have to, and check you've still got room for a door to swing and a dresser drawer to open without doing a little sidestep every morning. Low frames also change how a room reads height wise, so check the ceiling doesn't suddenly feel higher than you want, or lower, depending on your walls. A good shop check: put your hand flat on the platform slats and press, you want solid support without a gap you could lose a sock in, because some of the cheaper slatted bases flex more than they should under a mattress that isn't firm enough to compensate.
The honest limit here is storage and softness. Platform style modern beds rarely have the under bed space a box spring setup gives you, so if you're relying on that space for bins, out of season clothes, the extra pillows nobody admits owning, check before you fall for the look. And a very linear, low frame can feel a little cold next to anything heavily textured or rustic, a chunky knit throw or a reclaimed wood dresser can end up looking like it's arguing with the bed rather than complementing it. It also tends to clash with ornate headboards, tufted anything, or a very traditional wallpaper, the lines just don't agree with each other.
What makes a good one worth living with, longer term, is the detail you don't notice until you're half asleep, a frame low enough that you can swing your legs straight down to the floor without the awkward hop up or down that some low platforms force on you.