Of the three wires, no combination is likely to damage the boiler in your case, so would not really worry.
I also have two makes, Nest and Wiser, but these all can be worked with Google Home app in my case, so only one app for all my smart devices, the same with Alexa, one app works all.
Interesting as to compare linking to TRV heads v works with OpenTherm, think personally linking to TRV heads is more important.
However yes I am nervous of working on a central heating system in winter specially the weekend, as need to fix fast, and finding some one on a weekend not easy. And yes when I fitted Wiser (same back plate as Hive so same connections) I did find a fault, the heating would not turn off, however this was nothing to do with fitting Wiser, it was a micro switch stuck in a motorised valve, which was likely there before I started, just I had not realised the fault existed before I started work.
But what I can't work out, is how Hive works with UFH?
View attachment 363919 this
View attachment 363920 may look like a TRV head, but it is hard wired, not sure if you can replace them with smart TRV heads?
Underfloor heating is very slow to react, I found out in mothers wet room, it needs to go on hours before it is required, and geofencing is in the main activated when one is nearly home, I tried it with Nest and Energenie, and in both cases, it detects one is near home far too late, handy to auto turn off heating when you leave home, but needs manual intervention to turn it back on in time for your return.
So back to basic question, why do you want to change to Hive, what will it do, that the system you have will not do?