Im interested in this too as my experience is the same as yours.

Personally I feel like going in to JS/G apps script is actually a big bonus as it means you avoid some of the really gross stuff that you get in excel (which ime ends up being really hard to maintain).