Thanks to my good friend MrHeroSlayer and some others for helping me out with this experiment. It takes a little while but sharing a High Value Target mission through Near DOES in fact work for friends that aren't even nearby.
I didn't have Scorpion unlocked until they tried sharing the mission and I didn't received the game good in Near until about 15 minutes later but it worked! So I finally beat that annoying mission and just have two more and I plan on helping others on my friends list as well. Just wanted to say that it works. I'm just glad. Thank you.