fix: comprehensive codebase review fixes (critical + major + minor issues)

feat: scaffold complete RAG system for RICS-style report generation