When do dual cpu systems make sense?

You should start with the basics. Understand ZFS, pool layouts, performance tradeoffs, special VDEVs, pool free space, etc. Make appropriate choices that match your goals for your system.

BASICS

iX Systems pool layout whitepaper

Special VDEV (sVDEV) Planning, Sizing, and Considerations