Alright, I am now fully equipped.
Linksys WRT54G v3.0 reflashed with DD-WRT firmware
Static DHCP entry for Dish TV receiver, because you can't set a static IP on the POS (DHCP only), and it tends to wander about, which makes the Logitech Revue angry because it expects the Dish box to stay on its original IP address. How Logitech and Dish expect the average consumer to not be frustrated by that, I don't know. (Not relevant to downloading games, but something that's been bugging me, and OEM firmware didn't have static DHCP capabilities)
Wake-On-LAN enabled on PC, NAT entry with ARP hack set up on Linksys per http://www.dd-wrt.com/wiki/index.php/WOL
Android WOL app because it's amusing to use my phone to power up my PC, and because it saved me from having to fire up another computer to test my WOL. https://market.android.com/details?id=com.benfinnigan.wol
RDP passthru to home PC.
Never again will I fail to have a Steam game pre-downloaded and waiting for me when I get home from work!