Microsoft 365 is the reason why the new add-in model is focused on Web technologies, and mostly deprecated going forward for new forward.
Regarding COM, it wouldn't be that bad when using COM Servers.
However I do agree that although COM as idea is enticing, Microsoft keeps failing to deliver a productive way to use it, despite how much they keep focusing on it for Windows extensibility and API delivery since Vista.
And my advice now is for .NET devs, stay with Windows Forms or WPF, depending on which approach they favour.
For C++, I suggest the aging MFC if it has to be on the Visual Studio (still better out of the box experience than WinUI 3.0 for C++, and C++/WinRT is in maintenance anyway), but really Qt or C++ Builder are much better option.