I completely understand the 8GB happy users. Well not completely, but for their use it seems to hold up for them. For me, the 8GB really choked up even just doing Safari with a few windows and tabs. Then, if I tried to add Main with my 2 accounts, that was not really usable, it slowed to a very very slow crawl.
BUT that was also the first weeks that the M1s and Mini was released. I believe we were using Big Sur, not sure the version. But at least a few more Big Sur updates came out after that as well as Monterey now, which is even more optimized for these systems I think.
So maybe now, with Monterey, the experience on an 8GB is not as bad as it first was? Yes, if you need to do a "lot" of things at once, I'd save for the 16GB version, or if you have the extra cash, I would just go for it as you will be very happy.
But if you are at the max budget with the 8GB price, I would say go for it and at least give it a run. Just be sure to try everything out that you'd normally use it for within the first couple weeks so you can return it if needed. I think Apple's return policy is normally 14 days?
if someone could correct that if I'm wrong?
Then at least you know how it's going to be running for you for the foreseeable future. If it runs too slow for you to handle (it could be as simple as just the right or wrong combo of apps being used that cause it to work for you or not). As some have mentioned, if you say use lots of web browsing with lots of windows/tabs and then also want say Slack and from what I hear, MS Teams (which I don't use but hear is very bad still on the Mac, though it works, just lots of memory and resource consumption from it), then you might think of things and go for 16GB.
If none of that really applies to you, and you'll be using this new Mac for things like light or it sounds like even normal web browsing, running something like Pages or Numbers (or MS Word/Office though I don't have experience with them in the past few years so I can't comment how optimized they run) then I think you'd be fine with 8GB. But I have to just add that if you can spring for 16GB without breaking the bank, it's still worth it
Also just to make sure we aren't confusing you, I don't think any of us in this thread have mentioned going up further to something with the M1Max or Ultra or anything like that. From what you've said, those are way above your needs. Of course you'd love those systems (I would too!) but you definitely shouldn't need one at all unless you now tell us that you do video editing in 4K while encoding or such. Just wanted to clear that up if there was any confusion.
At the end of the day, I know this thread is split with many happy with their 8GB version while others like me say to get the 16GB. But it really does mostly come down to how you'll be using this machine and to do what. If you can give us some more details into the work/tasks and also any apps that you definitely plan on using (even generals like just web browsing and email) then we could help steer you better. Without more info though, I would feel bad if I didn't post to test that 8GB machine thoroughly in the first 10 days or so. If it is sluggish for something you do all the time, then if you can afford it try returning for the 16GB version and I'm sure it would solve most of the problems, if you encountered any.
But maybe the more optimized macOS that is out now is a lot more efficient than when a lot of us 16GB users originally tried the 8GB models and it makes a world of difference. Possible for sure. So buy and try!
And please let us know how it goes. This forum is obviously made up mostly of Mac users. Most of us love to help others out, like we've tried to do here. It's always great though to be able to hear followups after the original poster has tried any of the recommendations mentioned or something else completely. I for one, would love to hear your experience if you go for the Mac switch from your old Dell machine. I also hope this thread hasn't scared you away completely, most of us just have strong opinions due to past experience, like my own 8 and 16GB usage trials. You'll love the Mac and whatever version you get, you'll be happy with I think.