What I don’t understand is the totally arbitrary cargo cult nvarchar limits. Why 255?
If you can guarantee you’ll only store ASCII, you can safely use 255.
This is also probably a premature optimization for practically anyone to be fair. Even at 1 billion rows, you’ve only added 1 GiB of overhead, and at that scale that’s a small percentage of the overall size.
I remember that the ancient Pascal dialect I used in college had max array sizes of 255 because they used a single byte for the size.