Update E2E Tests Part 2

[wilwade]

Goal

The goal of this PR is to increase the speed and readability of the e2e tests.

Part of #2003

Discussion

• [x] Split up Staking and Capacity Transaction tests
• [x] Remove the Rococo e2e test workflow (no longer viable)