My latest ASUS was good enough, but I didn't (and probably won't) build any newer systems, so ABITs will have the crown.
I seem to recall that only Quake 2 or 3 was capable of actually using that second processor during a game, but that wasn't the point ;)
It was fun to play with but you'd also expect the higher-end desktop to e.g. handle x264 videos which was not the case (search for q6600 on videolan forum). And depressingly many cheaper CPUs of the time did it easily.
I loved it, to be honest.