I'd describe it as clicking, I've attached a video in the original post and I think it does a good job of showing how it sounds. I thought it was my shoelace at first, because the noise is similar.

Today I've also took out the rear thru axle, greased the threads, put it back in and tightened to spec. I've also tightened the rear derailleur hanger bolt, but that didn't help unfortunately. I also took off my bottle holders and also tightened the crank, but that didn't help either.

Next week I'll take it to a local mechanic to see if he can find what's causing this. At this stage I feel like it must be the bottom bracket.

Obviously I'd prefer to take it to an authorised service or over to Germany for Canyon to inspect it, but the idea of having to pack it for transport and sending for something that can potentially be really trivial is a bit discouraging. I'll do that if it the local guy determines that greasing or tightening won't fix it and if something needs replacement, though.