Sharp results for the Weyl product on modulation spaces