Local-to-average crystal structures and mechanical properties in High-Entropy and Compositionally Complex fcc, bcc and hcp-based alloys studied by synchrotron methods