Running Craft CMS 2 on MySQL 8.0+ (Any major considerations?)
Sounds like you've overcome the obvious ones already.
We've done some limited testing with the latest Craft 2 release on MySQL 8+ and no other red flags have been raised from our experience.