Indeed I have a number of Atom 330 1U pfSense boxes in the wild running squid, squidGuard, ntop, etc, and they are great performers.
The CPU requirement depends completely on the amount of throughput you need (in PPS, or more generally, Mb/s), along with the number and type of services you want to run.
Sweeping generalizations like that really aren't helpful to anyone.