At Pitt I can go to the library's website and request journals they don't have access to, I get an email the next day with a .pdf of the journal article requested.
You can automate the VPN'ing. Or, in my case, I just use an on-campus computer which doesn't need to VPN. What you can't automate away into instantaneousness is the delay of waiting a day for a paper to get there.