Ok, here’s my experience.
When I started MTB it was all about more gears. My first foray into MTB had 3x7, which was replaced by a 3x9 and that by a 3x10. Thirty gears! THIRTY!! Then the world moved on and 1x became the thing. I also realised that out of the 30 gears I had, I really only used about 12 to 13 of them, those being all 10 on the middle ring and then occasionally the largest 2 gears on the smallest chainring and the smallest gear on the large chainring, but the occasions I moved off of the middle ring were few and far between. I generally got on OK with 3x but occasionally it would get all clagged up with mud, to the point of having to stop and clear it sometimes. And there was always the chance of chain rub.
Then I made a project gravel bike out of an old MTB and I made it 1x10, just becasuse I could and I didn’t have one. I immediately discovered that I didn’t miss the front mech and liked the simplicity and no mudclag. I had geared it for climbing (34T, 11-36) so it did spin out on fast roads but it spent most time offroad anyway so I wasn’t that bothered, but even so once I had proved the concept to myself I fitted a wider cassette (11-42) and longer chainring (36T), which is how it now stands.
In the mean time I picked up a modern full-sus with 1x12 which never left me without a gear, so I look back to my venerable hardtail, with those 30 gears. Eventually it came time to replace the cassette and since I was in the mood I decided to update the whole chainset. I picked up a 11-46T cassette and fitted an oval 36T ‘ring, along with an appropriate derailleur and chain. At first I noticed the big gaps between gears but soon enough I got used to it and now, once again, I enjoy a simpler set-up which is easier to clean. Again, this bike is off road almost exclusively so I rarely spin-out and if I do so what, I am not chasing time on the road.
My road bike is 2x10 and will never go single-ring, as it works better for the riding on road.
So, in summary….. well, I’m sold for off-road, yes the cassettes are big and costly but the bikes are simpler, easier to clean and far less likely to get bunged up.