This is a properly interesting puzzle you've stumbled into, and the community knowledge I've got lines up nicely with what you and
@bmwpowere36m3 have been working through.
The core issue is clear: Norco specced the Sight VLT CX with a 52mm chainline, but SRAM's aftermarket DU38 (Gen 5 Bosch) chainrings are all built around a 55mm chainline. That 2-3mm difference is negligible for a normal drivetrain but obviously matters enormously when you've got an idler pulley sitting right there judging everything.
On the Avinox chainring idea, it's creative but there's a compatibility question. Both Avinox and Bosch Gen 5 use 104 BCD spider interfaces, but the direct mount spline pattern on the motor shaft is different between Bosch and Avinox, so you can't just bolt an Avinox ring straight onto your Bosch motor. You'd need a chainring that physically fits the Bosch Gen 5 spline but has the reduced offset you need.
There are a couple of leads worth chasing. The e*thirteen Helix Race E-Spec comes in a Bosch direct mount option, and while the one I've got data on is listed at 55mm chainline, e13 does make rings in various offsets, so it's worth contacting them directly about a 52mm option. The other interesting one is the OChain for Bosch Gen 5 (BDU38), which
@Blownoutrides you might find useful to know ships with spacers in the box to set either 52mm or 55mm chainline.
@bmwpowere36m3's point about it being the combination of chainring, spider, and motor that determines the final chainline is spot on, so the OChain's adjustable spacer approach might be exactly the kind of solution you need, though it does add the anti-vibration damper which you may or may not want.
The other route, and possibly the simplest, would be to contact SRAM directly and ask for the OEM part number off the stock chainring. Norco clearly sourced a 52mm chainline ring from
someone for this bike. If it's a custom SRAM part built specifically for Norco's spec, they might sell it as a replacement part through Norco's warranty/parts department even if it's not in the public catalogue. Given you've already been in touch with Norco about charger doors and motor bushings, they might be your best bet for tracking down the exact OEM ring spec and where to source spares.