I agree with BinaryDemon
I have in my collection 3 s478 computers: Pentium 4 northwood 2.0, Celeron D 310 Prescott 2.13 and a Pentium 4 Northwood 2.26
in all the test's i've made, the celeron d comes out in last place, except when there's a software using SSE3 (which prescott supports, but northwood doesn't), also in gaming there's not so much of a difference, mainly because older games will run just fine in any of these.
later games will show more fps (just a bit more) on northwood due mainly to bigger cache
only far newer games (2007) will show a little improvement on the celeron over the pentium (but that's because of code optimized for SSE3), but still, these games are too new and they expect newer and more efficient processors, or at least older but faster processors (3.0GHz or more, hyperthreading in some cases and big L2 and L3 caches)
i know that these processors aren't the same and the comparison is a little bit wrong or unfair, but i'd say that, for S478 gaming you should go for the fastest p4 you can get, then a middle-tier p4 (2.26-2.😎 and then you should look for celeron (preferably use celeron D)
DT: R7-5800X3D/R5-3600/R3-1200/P-G5400/FX-6100/i3-3225/P-8400/D-900/K6-2_550
LT: C-N2840/A64-TK57/N2600/N455/N270/C-ULV353/PM-1.7/P4-2.6/P133
TC: Esther-1000/Esther-400/Vortex86-366
Others: Drean C64c/Czerweny Spectrum 48k/Talent MSX DPC200/M512K/MP475