
Samsung
Q990F
Value for movies and easy setup, but music falls flat.

Running these analyses costs money. Buy through my links to help keep lights on! I may get a small commission.
Maybe get the old arc on discount and add the 100s as fronts with Sonosequencr. Great for music and TV.
Since they added adjustable speech enhancement it's significantly better. Before that it was maybe a 10% upgrade.
Could also go for the non-Ultra Arc if you want better than the Beam but still want to save a few hundred compared to the Ultra.
I have the original arc and love it and wouldn't look back or change.
If you’re moving from traditional AV, the only option for you is: Sonos Arc / Ultra Era 100 rears as you have mentioned Dual Sub 3/4 I did the same thing, it’s not the same as traditional AV, but it’s a very good compromise that just works and looks great.
I’m rocking a first gen Arc with a Gen 2 sub and Era 100s as fronts and rears. It sounds fantastic in my space. I considered an upgrade to the Arc Ultra, but I listened to my neighbour’s and the juice isn’t worth the squeeze for me at current pricing. I’ll most likely hold on to my Arc until whatever the Ultra’s successor is.
For Atmos, you need either the Beam or the Arc. Sub and rears are not required, but definitely add to the envelope.
With the Arc, you'll notice height channels and some front L+R (if your room layout provides for sound bouncing off of walls), but to get a proper Atmos experience, you'll want 2 x rears. Era 300s are your best option there, but I use 100s and it still sounds immersive.
That thing still negates the upward-firing and side-firing speakers. Sonos even specifically recommends against enclosing the Arc.
Arc Ultra + 2 x Sub 4 + 2 x Era300s rear surrounds, and set “Music Playback” to “Full”. For a contained system for both movies and music, that’ll pack a punch.

Samsung
Q990F
Value for movies and easy setup, but music falls flat.

Sonos
Beam (Gen 2)
Compact value, but virtual Atmos and app issues.

Samsung
HW-Q990D
Powerful, immersive value, but poor music and buggy software.

Sonos
Arc Ultra
Immersive Atmos and bass, but pricey and poor for music.

Samsung
Q930F
Strong value for movies, but music and HDMI 2.0 limit.

Ranked #1
Sonos - Beam (Gen 2)

Ranked #1
Samsung - Q990F

Ranked #1
Sonos - Arc Ultra

Ranked #1
Sonos - Playbar

Ranked #1
Sonos - Arc Ultra