Yuki Tanabe shares some strengths and weaknesses of Google Apps Script as well as criteria for choosing Google Apps Script for your coding project
Source: I summarized my own practices on what Google Apps Script is strong and when to use it
Member of Google Developers Experts Program for Google Workspace (Google Apps Script) and interested in supporting Google Workspace Devs.