My go to back in The Day was just Ubuntu because I was lazy. We're talking the 14.04/16.04 days. Ubuntu was simple and mostly just worked. I now find myself needing to de-spywareify as the coming administration is likely to force Microsoft into tracking "dissidents" so need to get back into weaning myself off the Windows teat.
I recently dualbooted my main desktop with Ubuntu 24.04 and have been... entirely underwhelmed. The whole separation between APT and snap packages doesn't work well together and is really the big problem I have, as a lot of standard deb packages just refuse to install properly now. the UI is hard to use and doesn't make me happy, and it's not been playing nice with my Zen 4 desktop when it comes to ACPI power states (no sleep, doesn't reliably turn the power off when i ask it to turn off, etc). So overall, I am just not terribly interested in using Ubuntu anymore.
What I primarily want is the sort of "mostly just works" like old 16.04 but still gave you the full ability to monkey under the hood- and is also something based on a normal distro that most people write guides for because I am a smoothbrain. Should I just head to using basic plain jane Debian or something?
Set and forget: Arch Linux. There might be much setting involved, but you can forget later.
Don't even set and you can forget: Linux Mint.
I think OP wants something that also minimizes the "set“ part. Arch is for enthusiasts who like to put a lot of effort into creating their own perfect Linux system. I've tried it once and to be perfectly honest I don‘t want to fiddle around with basic settings if there is no need to. I'm pretty busy with other things in my life and want stuff to work out of the box with sane defaults if possible. It's essential that stuff can easily be customized afterwards though.
Arch is very good for people who want to invest time into learning what goes on under the hood. Perfectly valid use case, but probably not for OP.
For this purpose Mint is great. Comes pretty much preset to use and requires almost no maintenance for normal use. It's like Windows used to be in the past.