@anu I had the exact same question. Kyle’s answer is completely correct.
The hardware shakes out entirely as you would expect.
- Pi Zero - Painfully Slow
- Pi Zero 2 W - Much better. Usable, but still pretty slow
- Pi 4 Wireless - Fantastic
- Pi 4 Ethernet - Best in Breed
If you have your choice, go with a Pi 3 or better with a full sized breakout board. That one has LEDs to make diagnosing problems even easier.
The size of the compact breakout can be problematic with ferruled wires. (Yes, you can still use the bigger breakout board with a Pi Zero. It’s just wonky because of the size difference.)