I know of one that will be a major pain: the Apani VPN client. It's the only way to VPN into a Nortel VPN from OS X and has never been ported to Intel. It is the only reason I had to put Rosetta on Snow Leopard. I get the feeling it will likely never get an upgrade since it feels a bit like abandonware already. Here's hoping my employer switches to Cisco.