The flavourful present and future of 2HDMs at the collider energy frontier