My issue with TUIs is the lack of a simple interaction model. Every tool invents its own navigation style like vim bindings, custom key combos, mouse-driven flows and there’s no common fallback. In GUIs, the mouse is always there if nothing else. Even basic things like tabbed navigation can become confusing in TUIs sometimes

Sure, for a lowest-common-denominator, GUIs and websites will let you use a mouse. That's great for if you want to use a tool & don't want to take time to get familiar with it.

There are some things which are inherent to GUI or CLI interfaces.. but, overall, nothing ensures a TUI will be good, and nothing prevents a GUI from providing a good interface. -- The distinctions are generally going to be program specific.

So e.g. using openlens (GUI) vs k9s (TUI) vs kubectl (CLI).

Very interesting writeup OP!! This sounds like something definitely worth trying!!

Very interesting writeup OP!! This sounds like something definitely worth giving a try.

If anyone has other interesting link blogs, do share them here

A bit off topic, can someone suggest how I can learn more about using databases(postgres specifically) in real world applications? I am familiar with SQL and common ORMs, but I feel the internet is full of beginner level tutorials which lack this depth.

For PostgreSQL, the manual is extremely well written, and is warmly recommended reading. That should give you a robust foundation.