I had tried that route! Still trying. What I am doing now is to make an attempt at ‘neatly’ printing inside of Notability (now Goodnotes), using text conversion and just copying certain information over to Pages or MS Word. Using the pencil to cut, copy and paste is such a delight for me - I can’t type fast; but I can chicken scratch w/speed and most text can be recognized.
Tom
Sounds like you've put a good amount of time into your workflow here, so you probably already know this, but just in case I wanted to point you to Apple
Scribble. It lets you handwrite anywhere you'd normally type, and does the text conversion automagically. I have horrendous handwriting, and it does surprisingly well on mine. I've avoided handwriting recognition apps generally because I get such a low success rate-- but the Apple algorithm seems to do well for me. I assume if I worked on adapting to the machine a bit it would do even better.
In the Pencil palette, there's a pencil with an "A" on it, that's the magic one.
Just experimenting over the last day or so, I've been able to open Numbers, touch the pencil on a cell, and write numbers that the cell converts to actual numbers (the occasionally confusion of "13" and "B" notwithstanding). I didn't actually try handwriting formulas, but I'd guess they work as well.
In Pages, I can open a document and start writing freeform text that gets converted as I write. I can create tables within Pages that I can tap cells and handwrite numbers into. Pages tables are actually Numbers sheets, so I can add formulas and create charts within Pages. I can add drawings and sketches.
The one thing I can't seem to do is draw on top of the text, which I find rather frustrating. When I draw, it creates a separate "drawing" space. One thing I tend to do with handwritten notes is draw on top of the text for emphasis or reference, and I can't seem to do that within Pages itself. I seem to recall that being a limitation in Apple Notes also-- I can draw over handwritten notes, but not typeset ones.
Anyway, not advocating anything, you seem to have a firm understanding of what you need, but on the off chance any of this is helpful...