In-depth study of moderately young but extremely red, very dusty substellar companion HD 206893B