TEMPORARY SOLUTION
After an exhaustive search and hours of trial and error... There IS a solution... Kind of...
Obviously there is some type of protocol that OS X doesn't seem to agree with when connecting to the Bell Sagemcom to access the USB drives there. (Dear Apple, this is waaaaay above my knowledge level, but please fix this!)
However, I happne to be running VMWare (running Windows 7) on my MacBook Pro so when I tried to access the networked USB drives from inside Windows 7, Ta-Da!... There it was. So I am now able to drag and drop files from there right onto my Mac OS X desktop.
I would assume this will work with both VMWare and Parallels running a copy of Windows.
Would really be nice to just have Apple fix this though, because clearly it is possible. (Nothing is worse than when you know something COULD work, it just doesn't... So annoying!)
Hope this helps for now!