“What if we just used NVARCHAR(4000) as the default datatype parameter for any query, regardless of what datatype the table has in it – like numbers or dates?”

Brent Ozar with an interesting example on why (almost) everything could be nvarchar.