Undersizing:
Undersizing can cause the motor to fail to lift the curtain and shut down.
Oversizing:
Oversizing can cause the motor to damage the hangings suspension or stops.
Also, due to the lack of load, it is possible that the temperature limiter will trip sooner.
For information on selecting the correct motor rating, see this article.