Ideal or not,
Apples TB -adapter is listed compatible with FreeBSD, as are even Power Mac G4 and later PPC stuff, so I hope I am good with my 4 core Mac Mini i7, Apple Thunderbolt adapters, TB docks etc.
Yeah I know it is. I use FreeBSD a lot. It will absolutely run on a G4. But package support is another story. I usually use it as a desktop when macOS isn't an option.
FreeBSD supports Realtek adapters too. They're just not super reliable, especially for a sever environment.
My first pfsense box was an old AMD dualcore, using the onboard NIC, which might've been broadcom, and a PCI NIC, which
was Realtek. I had it set up like that for about a year.
I moved to the i5 system for a couple of reasons. The AMD box was an ATX mid-tower, I wanted it smaller. It was a 65W CPU, and it didn't support AES-NI. I think what I have now is an i5-2390T. Lower TDP, AES-NI support, and its a SFF mini-tower. When I was using the AMD box my connection was different. My old ISP gave me around 900Mb~/400Mb~.. That's not to say the symmetrical Gig wouldn't have worked on the AMD setup, I just had changed boxes before getting a new ISP.
That said, I did experiment with USB dongles. Never got a working solution that could handle the connection, or run stable for more than a couple of hours.
Also, not totally relevant to the conversation, but in some of my experimentation just to see if I could.. A PowerMac G4 Mystic (Gigabit) with an xserve G4 NIC as a second port, can indeed do routing\firewall functions with Leopard Server. But you'll only get about 10-20Mbps 😂 Can't imagine it would've been the most secure firewall either.
You probably will be more than fine using that Mac Mini. Just be aware of what adapter you use, and how its connected to the computer.