Constraining cosmological extra dimensions with gravitational wave standard sirens: from theory to current and future multi-messenger observations