The formula field reference is missing the most basic array functionality - retrieving information based on index. If implemented, there are many use cases. Here’s one:
Assignments collaborators
Amy, Peter, Tanya
Stage number (int)
2
Current Assignment formula
{Assignments}[ {Stage} ]
=> Peter