I have a Smart Keyboard Folio case, which is super slim and light. My 12.9" 2018 iPad Pro is smaller and light but still has a good keyboard feel. (Note: I have a mechanical keyboard on my home Mac, but can still type like a demon on the thin iPad keyboard. It's surprisingly ergonomic.)
I know there's basically no chance I'll be able to run Emacs or VS Code on this portable little device any time soon, but if I could, it'd be my main device by a long way. There's no hardware limitation preventing it, just artificial restrictions on a "pro" device.