Unreal Engine 5: Python or C++ (Which one to use and when?)🚀✨

I wanted to ask this question and I got a short superficial answer from Google's Gemini
but I think it paints a clear picture.✨