I'm trying to figure out how I could fetch the contents of another block by
name from an elisp script

I've seen `org-sbe` but I just want to get the block contents, (ideally
with noweb and vars filled in - just as it would be tangled if we were to
tangle it)

How do I do that?