Am I the only one that finds the Google Sheets API not fully baked or has had issues with it? Search functionality is not there, retrieve row, find and replace

Am I the only one that finds the Google Sheets API not fully baked or has had issues with it? Search functionality is not there, retrieve row, find and replace is not adequate, row index not sent when retrieve values etc. Updating particular row gets hard etc. We ended up adding row counter as a column as well. We used Sheets in between two major iterations of our internal tools and we found it inadequate for any advanced usage. Also sheets api would tend to 503/504 (not sure which one) if there was more than 10k rows with 4-5 columns.