What kind of performance might one expect for collection sizes of several hundred thousands of documents? Like, how can we determine if there is room for improvement indexing wise or if we need to scale up our cloud instance?

It will depend on your traffic pattern, what kind of queries you are doing etc. Keeping a watch on query latency and CPU load will offer a good indication on whether you should scale up.