Actually, it’s quite safe, for both the Sweet Scent user and the target. If anything, it’s just as therapeutic for the user as it is for whatever they’re treating, as it’s a healthy outlet for their abilities. Think of it like exercise for a human being: it helps develop parts of the body while at the same time allowing them to release pent-up stress and maintain their psychological health.
As for the target, there’s no such thing as overusing Sweet Scent or Aromatherapy (or similar moves). The worst that might happen is that it may trigger pollen allergies, but that will happen upon a first use, rather than due to prolonged usage. For this reason, it’s not a treatment that should be given to younger children or those with known allergies, but for everyone else, it’s perfectly safe.