In my experience, from ~1.5 years ago, performance became an extreme challenge to overcome if you wanted to service user facing requests in <100ms (for a non-trivial sized graph). I really did enjoy Cypher though and the tooling around it was very polished. Tempted to try it again now that they have a new version.

Last time I looked at it it seemed to really want me to use Java.

Turns out the official Python client library is five years old now so I clearly need to update my mental model of what it can do!