nvarchar has a higher precedence, so the varchar -> nvarchar works fine, as noted by Mr. Poole.

http://msdn.microsoft.com/en-us/library/ms190309.aspx

Converting down causes the index issues. Lots of ORMs and some frameworks will submit N'' values and if you have varchar fields and indexes, they don't get used.