If your PSU does not have enough wattage your PC will crash, it may start smoking, it possibly will never work again even with a new PSU.
If your PSU is too small it is unlikely to cause overheating, it is more likely to just fail. If you are getting overheating symptoms then you may have other issues, poor airflow for instance.