I'm using a 945GCLF2 at work and it works fine with pfSense 1.2.3RC2.
Do update the BIOS or you might have issues with ACPI and some SATA drives.
It runs just fine even without a BIOS update except with the following quirks:
The bootloader won't see a SATA drive on occasion and needs multiple reboots to get it to load once.
One of the 4 cores (2 physical + 2 HT) will be permanently loaded by ACPI processes.
In short, it works well but you should update the BIOS.
For my machine, I have a 3M/768K line and average CPU load is <1%.
No packages are running and I'm just using it as a simple router with massive state table, nearly unlimited port forwarding and Traffic Shaping.
A pfSense rig should suit your needs quite nicely. They're quite similar to mine when I made the switch to pfSense.
I used to torrent to the tune of 25,000 connections per machine at home and nothing from Dlink/ Linksys with or without 3rd party firmware would survive for more than 5 minutes.
At work, I have 30+ computers in a cybercafe and some of the games open up quite a fair number of connections as well. Easily 500+ active connections per machine. So far, so good. The traffic shaper does it's job well and a lot better than with some of the Linux router distros I've tried.