Not exactly what you’re asking for, but have you considered something like this?

https://github.com/Guake/guake

Press a button, terminal drops down. Press it again and it rolls back up to the top out of sight. It’s based on how the console worked on Quake. I haven’t used it in a while, but my guess is that depending on what tiling WM you’re using you’ll get different levels of weird interactions with window geometry.