Is there any improvement in error reporting when Foreign Key fails (i.e. currently does not report which column and reference failed)?

The foreign key support in InnoDB has seen improvements in each major version of MySQL. However, global foreign key support (i.e., generically for all storage engines) is scheduled for MySQL 6.0 and should resolve any inadequacies in the current storage engine specific implementation.