As so many differing reports of wi-fi connection issues are appearing, I have thrown together a quick-and-dirty summary of known routers/APs mentioned in this and similar threads. Put simply, "Good" work with the Hero using WPA2, "Bad" don't work at all, and "Ugly" work but with limitations.
I don't claim that this is in any way definitive or scientific, but it should help anyone looking for help with an inop wi-fi link. Please post any further details you may have both on the listed hardware and any other devices, working or otherwise. The more info we have the better placed we are to help each other.
GOOD:
D-Link DI-524 (3.1.3b firmware on hw rev G2 only)
Draytek Vigor 2600G (2.5.9_UK firmware)
Linksys WRT54G (Tomato v? firmware; link still drops infrequently)
Linksys WRT54GL
Netgear DG834G
BAD:
Belkin F5D8636-4 (No WEP64/128, WPA/WPA2)
Gigabyte GN-BR01G
Zoom X6
Zyxel P-2602HW-D1A
UGLY:
Belkin F5D7230 (WEP128 only; No WEP64. WPA/WPA2)
Belkin F5D8321-4 (WEP128 only; no WPA/WPA2)
/Al