My Raspberry Pi4 started with a "I'd like to get experience with Linux and install Pi-Hole." Ended quickly outgrowing from discovering a lot of other cool options I could do with it.
I wanted something with a small form factor, quiet, good value, and did hardware transcoding for my Plex Media Server. I found this little guy with an Intel Alder Lake processor with QuickSync.
Very happy with it. If anyone is thinking or in the market for one, check it out here.
I ended up with a CWWK mini pc that is martketed as a firewall. Has a intel n305 which is fairly powerful a d 32 GB of ram and the ability ti run 5 nvme drives for nas functions. It is a great little VM/docker system.
I'm also using DietPi on a mini PC, works great. I like some of the built in tools it has. For a beginner or someone getting back into Linux the pre configured packages it has are nice.
That being said, I think when I upgrade I am going to just go straight to Ubuntu Server now that I comfortable with it again. I used to run a remote hosted Linux web / gaming server years ago.
Just to throw another suggestion out there, you can get second hand thin clients on eBay for fairly cheap, that are x86 based (vs ARM for a Pi), have slightly better performance than a pi and overall is probably going to come in slightly cheaper.
In the last couple of months I picked up a Wyse 5070 thin client with a Intel J5005, it runs at less power than my Pi did via a PoE hat (2.5w vs 6w) and should be able to squeeze out a bit more performance. I think I grabbed it for around $50 off ebay, which should be cheaper then what you can get a pi for (at least last time I looked).
Might be a hot take, but unless someone needs the gpio pins a raspberry pi provides, Iād probably recommend one of these first (or something similar).