yeah, the type of person that would use this would know Python (or JS), in which case they'd want to use that.

I noticed the same thing (technical spreadsheet users) and built Wax[0] to make it easier to build apps on top of Google Sheets.

0 - https://www.wax.run/