A good and short conclusion I’ve read here - Manual Testing vs. Automation Testing: Which is Best?
They’re both great. The main idea is combining these two approaches when needed and not sticking to one.
Manual testing works best for Exploratory, Usability, and Adhoc testing.
Automated testing – for checking the UI, the main testing flows, and rarely-changing cases.