What do you think about making a mod that would make SMF work with only the newest version of PHP and MySQL. It would make use of their functions and features.
Foreign Key Constraints, InnoDB, stored procedures, triggers, INSERT ... SELECT, lots of PHP and MySQL functions.