Both Eastern Beaver and I were puzzled on why/how the my bike would draw so much current for a longer time frame (longer meaning roughly more than 5 minutes, enabling heat up to above roughly 350°C).
As posted earlier, I did add a custom device for enabling safety light and changed back to halogen head lights (to circumvent possible issues in Germany). It triggered me to make a overview of the power usage and I had a look at the electrical schematic.
Original schematic: VFR800-FIW:
schematic_vfr800fiw_original.jpg
Schematic after installing 'RR directly onto battery':
schematic_vfr800fiw_after_EB_kit_depicted.jpg
For me this explained why the 30A fuse melted/blew in case of 'RR directly onto battery': all current directly consumed and charging the battery must pass the added 30A fuse near the RR, which wasn't the case with the original electrical layout.
In the original electrical layout, the RR provides electrical power parallel to the 'direct consumers' and the battery (if in need of charging) via the main fuse B of 30A.
The fact that the 'main fuse (B)' was fine / did not melt supports that additional current was drawn to charge the battery during the build up to failure. Namely, if the current draw was mainly from the 'direct consumers' the 'main fuse (B)' of 30A should also have melted.
The VFR800FIW stator is specified to deliver 470 W but at 5000 rpm, giving 34 A @ 14 V.
Before the moment of failure, I spend about 20 minutes motorcycling through a traffic jam (allowed in the Netherlands) and ran my hazard lights at low RPM (draining the battery). I cleared the traffic jam and RPM got up to 5000 and for roughly 20 minutes the battery was charging (hazard lights disabled).
My situation (VFR800 + added hazard lights) could be considered unique due to the additional load of the hazard lights device. Anyways, I changed back to the original schematic and did run error free ever since (I did upgrade the connector set that connects the RR to the main wiring harness).