Co-Designed Architectures for Modular Superconducting Quantum Computers