Im pretty sure most MoBo's have 3-pin fan headers.
Also, to answer your question, there are a few options:
The Thermalright XP-120 is probably the best, but it's big and it's not cheap.
The Thermalright XP-90 is almost as good as the XP-120, but it's smaller and cheaper.
The Zalman 7700 series is the same size as the XP-120, but a bit cheaper (although Im not sure if they perform quite as well)
The Zalman 7000 series is the same size as the XP-90, and again a bit cheaper, and with similar performance.
Really, any of these are better than the stock hsf.
Personally, Im about to get an XP-90, just so I can overclock without stressing that I'm going to fry my CPU. I chose the XP-90 over the Zalman 7000 series for two reasons. 1)It is MUCH lighter than the zalman's. 2)You can change the fan, so i can have a low speed to keep her quiet normally, then switch over to a high speed fan for overclocking.
RoD
EDIT: Here are the weights of the heatsinks.
XP-120: 370g
XP-90: 360g
(You will need to add about 100g to these heasinks, as they do not come with fans).
CNPS7700-Cu: 918g
CNPS7700-AlCu: 600g
CNPS7000B-Cu: 755g
CNPS7000B-AlCu: 438g