I'm wondering if it's possible to have one pi taking in USB data from a device then sending it to another pi over an LAN network which then shows up like it's the device on the other end. Trying to hookup a camera to remote control it but the usb over ethernet adapter I'm using seems to be pretty flakey. Figured I'd see if this is a possible solution. Thanks.
(Warning: I've never tried this myself.) The Linux kernel has usbip-utils, which offer USB via IP, and there's a usbip-utils README included. This readme includes usage sections for the server side, as well as the client side. These are rather low-level tools in that you need to look up the device bus IDs to be made available via IP. The readme walks you through these steps.
If a dedicated USB-over-Ethernet adapter seems flaky to you, I bet you will be disappointed by the speed of USB-over-Ethernet implemented using the RPi which is not optimized for this use-case.
One thing that might work is using the RPi to produce a video stream and transmit that (compressed) data over the network. You will need to figure out a way to remote-control your camera, which will be done outside of the video stream. Possible solutions include SSH, Remote desktop, or something like Synergy.