stuff like
this typically in the $100 price range and designed primarily for the DV camera market is available
This might get a camera to attach to your computer to transfer files, but something tells me it wouldn't provide sustained audio transfer without lots of pops/clicks, etc., and that's an optimistic outlook.
there is also stuff like
this typically for pennies that permit direct interconnect
I realize you are just making suggestions, but as others have explained, since USB and FireWire are entirely different types of interfaces to transfer data over, there's no way this thing could ever work, not just in the audio world. Perhaps there's some legitimate reason for its existence, but I'm not seeing it.
I have the same problem the OP does - bought a standard Macbook back when they had removed the FireWire ports. The regular Macbooks also have no PCMCIA or ExpressCard slot, so really, therr's no way to solve this problem. I ultimately bought a 300 dollar Core 2 duo Lenovo laptop that I attach my firepod to. While I wasn't thrilled about having to switch to audio production on the PC, it's the only answer short of upadingto a newer Macbook with a FireWire port.
You're welcome to try the first link i commented on (the adapter with some sort of processor in the middle for about 90 bucks), but as i said, since it's going through an extra data conversion process AND over USB in the end, the sustained transfer rate just isn't going to be there.