Ensure E2E tests don't access APIs or the DB directly

E2E tests should test via the UI only. Refactor any E2E tests that violate this principle. Any required setup should be done before the tests are executed. We should also update the testing standards that are documented to indicate this.