I can tell you I did it the wrong way.
In 2015, when I bought a DNS-410, I expected it to be the last cab I would ever need to buy. I actually get told to turn down at Music Festivals in wide open spaces if I turn the master on my 800-watt Eden amp up to 10:30. So no need to haul around an 810 for such events. And then I rolled my 410 into a small brewpub where the owner said it was way to big for their place and made me play through a small 112 combo. So I had to go out and by a 112 cab for that because we hosted Friday night Open-Mic Nights there over 40 times a year. Then, as I mentioned above, I bought a second one for medium sized venues. Used that 2x112 set up for about a year before I got accepted as a DNA Endorsing Artist and bought myself a DNS-210.
I have 4 cabs that I currently use. My mainstay is my DNS-210 cab by DNA. It handles 700-watts rms and gets so loud that I use it at all my indoor venues including large venues. Before I got that 210 I normally used my DNS-410 (handles 1400-watts rms) for large and outdoor venues as well as Music Festivals. I also have two Eden EX-112 cabs. I bought the first one for use in small venues and it sounded so good I bought the second one to use for medium gigs instead of using my 410 for the medium gigs. Still used my DNS-410 for large and outdoor venues as well as music festivals.
I've used my 210 cab in small venues, medium venues, and even large venues. At outdoor venues and Musical Festivals, I still bring out my DNS-410, but most of the time I'm playing indoors and just use my DNS-210 cab. And, at 52-lbs it weighs quite a bit less than the 79-lbs of my 410.
If I had it to do over again, I would go the way of buying two 210 cabs. Use one for small and medium venues and, if it's loud enough, large indoor venues too. Add the second 210 cab whenever one is not enough. Now two of my 210 cabs would weigh more than one 410, but I'd only need to pull that second cab out for outdoor venues and I can use just a single 210 the rest of the time. AND, I wouldn't have needed to buy 112 cabs I ended up with because nobody looks twice at a bass player bringing in a 210 cab. So one top-quality 210 cab would handle all my indoor venues.
I definitely recommend getting two top-quality 210 cabs instead of a 410.
Below is a shot of my 210 on top of my 410 with my 800-watt Eden amp above it. I only had the 210 plugged in and had the 410 there just in case the 210 wasn't enough. It was more than enough and my 410 was just an amp stand that night.