It seems like for networked listening, as long as the device can serve up the file quickly, there shouldn’t be a sonic advantage to other devices
...What I’m trying to understand is if there really is any sonic difference between them if running over Ethernet
There is, as in capital IS. Pursue different options to find out for yourself.
and the core is not located near the rack.
The Roon Core Component can most certainly be near, or in, or on the rack. Consider it an audio component and treat it as you would any other audio component in your primary system.