> And while notebooks are great for many things, they do make certain trade-offs that prevent them from being a full substitute.

Please elaborate on this. What are the tradeoffs?

I use VSCode and just add a magic comment #%% to split my Python script into cells and then I can run them as a notebook cell.