#571 [MEDIUM] Inconsistent error logging - some use exception() some use error()

Error logging is inconsistent across API endpoints. Some use logger.exception() which includes stack trace, others use logger.error() without full context. Fix: Standardize to logger.exception() for all caught exceptions.