So I'm thinking I like the sound of that sqlclr solution best, IF I can get it to work the way I need!

If I can get "impersonation" to work on the remote site from inside the clrsproc, that could be a pretty clean solution with very little code.