Raspberry PIs got me into Linux, python, networking and a whole bunch more.
Now, that's my job.
PIs are great for tinkering or quick jobs, specifically if you need GPIO or GPIO related peripherals and networking/monitor.
For anything that needs a computer with an ethernet port (web serving, pihole, docker, whatever) then buy some cheap knock-off or refurbished low power device.
For anything that only needs the GPIO then get some MSP32.
I've used PIs for doing crazy adapters between hardware and network. And they are awesome for that.
I've built a few projects that have also had a GUI. Also awesome for that.
But low powered PCs don't have the native GPIO support at the same cost.
And a lot of the knock-offs don't have the same library support. And certainly don't have the Linux support.
However, I made this decision a few years ago.
So, it's possible that my opinion is now out dated, and competitors have really picked up.
It's also easier for me to spend $100 knowing a pi will do it, as opposed to gambling (or spending more time/support time) on a more reasonably priced SBC.