I think this is really insightful. Every "good and invisible" tool I thought of fit neatly into one of those two categories. Examples:

Powerful and specialized: automatic transmission, display/monitors

Simple and limited: syntax highlighting, deterministic autocomplete

The closest ones imo that bridge the gap: ssh, google search