You mean Optiplex?
We have several of that vintage where I work (6th gen iCore.) They're fine for basic duties, we have a few in use every day. They're more than capable for a Linux version if you're into that.
If you wanted to get into Home Assistant, that's more than enough to do that...otherwise, perhaps you know someone that needs a decent machine but really can't afford something?
Yes you're right. Optiplex. They are i7s. I haven't popped them all open to see what they have for SSD's yet. The one 7040 I've turned on so far has all of 8GB of ram.
I've always wanted to put together something that has all of our movies stored digitally to stream to our TV.
Some of those could take up to 64GB. Fill that thing up and run https://jellyfin.org/
Oh cool. Would you recommend Linux for this application?
Good enough for any Linux deployment.
I used to suggest plex but they have been doing dumb shit so yeah, like @stupidbird suggested. Jellyfin is probably a good route.