Recently, I had to export some query results to CSV and Excel. One of the columns was extremely large query text which was defined as NVARCHAR(MAX). Here are some of the issues I faced with this request and how I over came them.
SSIS or the Import/Export wizard is fine. This is also a good use case for bcp or writing your own query using dbatools and outputting the results to file.