Add e2e tests mirroring user behavior based on feedback from sol, platform, devrel

[julian-risch]

• Get smoke tests from platform team and select subset for end-to-end tests
• Get example pipeline from sol and other usage scenarios
• Get Agent usage scenarios etc. from devrel