Improve failureReasons and error messages for failed actions

[fordN]

I expect there are going to be multiple related improvements here, so creating an issue to track them.

### Tasks
- [ ] Improve error message when failed to resolve POI due to no data for deployment in statuses fails an action

[fordN]

If a subgraph deployment being reallocate or unallocated is not deployed to the indexers stack at all the step to resolve POI will fail (as expected), but the failureReason is a bit unclear. It is marked as IE018 - "Failed to query indexing status API" which isn't wrong but isn't really helpful.

Added a task in main comment to track improvement of this case.