[Epic] Exception Recategorization

[MichelleArk]

Broadly speaking, there are 3 major top-level exception types that dbt raises:

1. "warehouse exceptions": DbtDatabaseError
2. "user exceptions": parsing exceptions, compilation exceptions, etc (caused by user project configuration issues)
3. "internal exceptions": DbtInternalError, or any unhandled, non-DbtBaseException exception

This epic organizes several sub-issues that recategorize existing thrown exceptions into more accurate buckets. For example, if an exception was previously marked as an internal exception, but is actually likely caused by user configuration, it should be a user exception instead.

Miscategorized Exceptions

Preview Give feedback

1. Missing macro in run operation should raise user exception (UndefinedMacroError) #11192
   exceptions tech_debt +2
   
2. Cycle should be a user exception (CompilationError) instead of RuntimeError (internal) #11194
   exceptions tech_debt +2