I have several use cases where it would make my automations much clearer and easier if I could find more than 100 records with the “find records” action.

250 records would solve a large part of the automation use cases, but the more possible, the higher the flexibility. Although I don't know what impact that might have in terms of performance.