Calling it very effective for cough is probably a bit of stretch. Some studies have shown that DXM is marginally better than placebo [1].

[1] https://www.cochranelibrary.com/cdsr/doi/10.1002/14651858.CD...