Reverse SSH tunnels
So I described why SSH, and SSH tunnelling, is so cool -- you can effectively port-forward over an encrypted channel to any accessible host at the other end. So I'm running a VNC server at home (so I can have X-Windows applications without a physical display, and have them continue to run when I disconnect), and I can fire up a remote desktop at work by entering localhost:5900 as my VNC server. It's a "forward tunnel".
But it's "reverse tunnels" that are really cool, because they allow me to connect to an RDP service (Terminal Services) at work from home. Firewalls will often maintain connection-state information, so can be configured to only allow connections to be established from "inside" to "outside".
With a reverse tunnel, the connection is established from inside (work) to outside (home) whilst I'm still in the office ... but when I get home I can piggyback on the reverse tunnel and get back into the work network!
C'mon, that's cool