theres so many things to do with a pc that i dont know where to start

Pick the first project that you think of and chase it down. If it sucks, then reformat the drive and do something else. Video game systems and file servers are great. So is installing a different OS on each, just to experience the differences side by side.

Do NOT continue "analysis paralysis".

Pretty sure there should be some nonprofit that will gladly get and assemble them so i.e. children on remote places can have a computer.

For any machines that are too inefficient to be worth continuing to compute with, you could at least save the power supplies for electronics projects. I've got some 12V addressable RGB Christmas lights being powered by an old ATX power supply, for example.

Cheap Linux desktops for a charity?

Put Linux on them and give them away to people who need them?

A lot, depending on your interests and the hardware itself. I'm running a NAS (TrueNAS) on an old machine that also runs a bittorrent client and immich as TrueNAS "apps." I'm running an *arr stack and jellyfin on another old machine. I've got another old machine running an i2p router, hyphanet node, and a few other services. In the past, I've used old machines as routers (pfsense), openhab/home assistant machines, game servers, ZoneMinder server, etc.

A nas or home server with one of them is a great idea

Some ideas:

• webserver (e.g. for a little personal website, maybe even host some fediverse things)
• irc
• weather monitor
• distro tester
• local LLM (they're getting more and more efficient)

If you've several of similar performance, you could:

• host lan parties, for classic games. Maybe some Quake, OpenTTD, Luanti

How old are we talking?

• Anything before core iX series is not recommended to be used as a server (missing instruction sets, low efficiency etc.).It could still be used for fun projects like installing gentoo or old redhat with plasma 2.
• If you have Core iX cpu (preferably 3rd gen or newer) you xan host some services, but look into c/selfhosted if you're interested in that.
• You could also experiment with Kubernetes and combine lots of bad PCs into one less bad PC.

In the end PCs are useful only if you can run useful sodtware on them, but besides nostalgia there ain't much use I see in them.

I have some hardware from like 2008 running my entire home's infrastructure. Jellyfin, Kavita, home automation, etc.

Turn them into a Kebernetes or a Proxmox cluster.

Turn them into a little server that you can host self hostable services on

I'm in a similar boat. I use old computers for spare parts and hobby projects (e.g. I did Linux From Scratch on an old second-hand Thinkpad I picked up on a whim). I think cheap second hand computers are great for tinkerers e.g. you can flash custom firmware without worrying about bricking the mobo.

You could also use them as servers if you have any services you want to host.

Also if you truly have no use for them, fix them up, install something like Linux Mint on them, and give them away.

I recently turned every old junker and some nicer ones into a Harvester cluster. The really old ones I use as cold storage devices that I actually shut off when I don't need them.

IMHO fix whatever you can, donate it all locally (HackerSpace, RepairCafe, Linux non-profit, etc) as there are quite a few people dedicated to refurbishing computers for schools, people who need a computer to find work, etc.

Then for the tinkering aspect, keep one, that's enough.

Honestly even 1 isn't really required. Pretty much everything listed here can be done more efficiently without an actual physical computer :

• your current computer can be a server, just turn off the screen or even accept (which I'd argue is a fair assumption) that at night it will be off. If you want external access put WireGuard or another VPN on it.
• Want to test distributions or anything else? QEMU or containers, no need for actual hardware

What kind of machines are we talking about here?

A recent-ish tiny/mini/micro is a vastly different answer than a kaypro luggable.

If you want something out from the ordinary, maybe build a retro gaming/tech museum and make it open for the public. You can even host events like gaming competitions, or thematic presentations. Charge a small make up for the costs, and maybe you can even make it your living later in life.

If less than 10 years old they're probably usable with some upgrades here and there. Finding a use for them is harder. Maybe just get them working and give them to friends who can use them.

Explore weird OSs! I got an old Celeron D workstation just for playing around with weird old operating systems.

Its got a 32 bit bios but 64 bit celeron, so the grub stuff has been fund 😅

How old are these machines, from oldest CPU model to newest CPU model?

Rip the parts out and pour epoxy all over them and make sure there are no Bibles in the pour.

Have giant tabletop made of computer

I've never seen one in person but they look soooo sick online

Install Win7 to make retro gaming machine?

A suggestion: if you can't find anything else for them, keep them around as parts machines.

There should still be useful components in them. For instance, a lot of the Wi-Fi modems may still be perfectly good for other things as long as they're mini-PCIE (I don't know if they use those in desktops). They may not be the absolute newest standard, but should still do the trick; it certainly came in handy when my sister's laptop's Wi-Fi modem decided to be a brat - I just swapped in an Intel modem from a laptop from 2016.

I might not fully trust the SSDs or the HDDs, but they can still have their uses. There's one SSD from an old desktop that I currently have hooked up to my Wii U.

I a year you might have an agent to manage them all. They could be edge devices, or different nodes in your/your ai's work flow. Don't get rid of them unless you hate AI, or for good causes.