1% Failure Rate - Help!

More detail needed. Presumably you’re using Zigbee, if the motion sensors are Hue? What integration?

Intermittent failures are often associated with too few mains-powered router devices. All the devices you mention are sensors, so not routers. You say the home network is “quite overkill” - is this the Zigbee network? Hue motion sensors have nothing to do with wi-fi.

Lots of good advice here: