Long-term use of Megace for appetite stimulation is generally not recommended due to potential side effects, including an increased risk of deep vein thrombosis, blood clots, and other serious conditions. Treatment duration should be as per the prescribing healthcare provider's recommendation.