Dropbox and Instagram use mypy/typing actively. Also among open-source:
https://github.com/home-assistant/home-assistant
https://github.com/mitmproxy/mitmproxy
https://github.com/sphinx-doc/sphinx
I would say the opposite, it is not very useful for small projects.