I own a Brother MFC-L2740DW printer/scanner and it has been working great for years with both Windows 10 and Linux. I recently purchased a new PC with Windows 11 (24H2) and have been trying to install the full package of Brother printer and scanner drivers. I have the exact same problem as the OP, the printer driver installs successfully, but the scanner driver fails. You don't find out though that the scanner driver failed to install until you try to scan from the Control Center 4 application. You will see a pop-up with error code CC4-202-00000008. There is a support article for this code on the Brother site, but the solutions provided do not work - they must be for an earlier issue.
Microsoft, a fix for this would be much appreciated.