This reply is in case you want to tile in KDE. I see you already found a solution with Yakuake / Guake tool and you don't need to change to a tiling system just for that.

Well if you would use tiling window manager in KDE with the extension Krohnkite, it has a feature for doing exactly that. You can set a window to be a Dock (I manually chose the shortcut Meta+D for that) and it will attach to any side you want and not interfere with the other tiled windows anymore. And you don't have to tile every window. In example on my Desktop 4, I set it to floating everything (which is no tiling at all) for games. You basically could set this floating mode be the default and whenever you want, you can start tiling specific Desktops or windows only.

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.

Yakuake

Press F12 (or whatever) -> Terminal drops down, in focus and always on top -> Press F12 again -> Terminal disappears.

What desktop environment/window manager are you using?

On windows, macos and linux I usually keep a workspace with a full sized terminal running tmux. The same workspace switching hotkeys native to the os or wm get me there.

I think in kde you can right click on the icon in the taskbar and choose 'show above other windows' or something similar.