Improve CLI UX and error messages

### Title
Improve CLI UX and error reporting
### Description
Focus on developer experience:

- Better errors
- Clearer messages
- Consistent formatting

### Acceptance Criteria

- [ ]  Human-readable errors
- [ ]  Source location info
- [ ]  Consistent style across pipeline