Agreed on that! The iOS RDP app is pretty darn good, and VPN connectivity options are really good too. BUT... I discovered that if I RDP into my work machine/network, it totally negates the need for both Coda and Transmit on my local iPad.
Thats the trick... :(