I had a similar experience with a Honda V65.
I could head a knocking noise under light throttle at mid RPM.
Using a stethoscope, I was almost sure it was coming form the #2 cylinder.
As it got worse, I changed the oil and found the oil had a brass colored metallic sheen, like you described.
I removed the spark plug and rotated the crank (in the normal direction) until the #2 piston was just past TDC. At this point, the connecting rod is pulling on the piston.
Using an extension for a 1/4" ratchet, I pushed on the piston and I could feel it move down a couple of millimeters. Then I knew I had a con rod bearing failure.
I tried one of the other cylinders and I could confirm a normal feeling.
Unfortunately, you might need an engine teardown even if you find the cause.