Well, mystery solved. I got the ASI174MM working on both the i5/Windows 10 and the i7/Windows 11 machine.
But, I had to revert to an older version of Sharpcap: Version V4.0.9478.0. The ASI174MM works in both 32-bit and 64-bit mode on Windows 10 (i5) and Windows 11 (i7).
I noticed that in the next release (Version 4.0.9481.0) that the following changes were made: Updated SDKs from Altair, SVBony and ZWO – bug fixes and support for new camera models. Whatever was updated (I presume by ZWO to that SDK - interferes with the ASI174MM as all of my other ZWO cameras (ASI1600MM Pro, ASI120MM, ASI071-Pro, ASI294MM-Pro) all work with all versions (current and past versions of the software) on W10 (i5) and W11 (i7).
Whatever changes ZWO made to the SDK interfere with the new version of the software for the ASI174MM. Sounds as if you have a bug or other issue with the SDK.