Dissecting the $H_0$ and $S_8$ tensions with Planck + BAO + supernova type Ia in multi-parameter cosmologies