As long as the length is not more than 4000 characters, DT_WSTR shouldn't be a problem. Varying length is not an issue.
DT_NTEXT is BLOB (or CLOB, not sure) data, so it has all kinds of restrictions. Most likely because it's not that easy to inspect it's contents.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP