Absolutely, in fact our work around since this JIRA was created was to implement the following in our custom Dialect implementation:

public class ExtendedSQLServer2008Dialect extends SQLServer2008Dialect {
  public ExtendedSQLServer2008Dialect() {
    registerColumnType(Types.NCLOB, "nvarchar(max)");
  }
}

I'll try to get a PR, but if not, it should be simple enough to add the registerColumnType line to the SQLServer2005Dialect where the CLOB data type is already being registered to cover both NCLOB and CLOB cases.