You mentioned that new 0w30 oil eliminated the sound, and I am curious...was the oil full before you drained it or was it low?
I know this is a long reply, but:
The oil was full (I check it weekly, and change it regularly). I was away to visit family over the week, so I left the Ody with my very trusted mechanic. He's now away for the holiday, so I won't see the car until later this upcoming week. I could post a video, but the sound is subtle, but different than what it has been. It's somewhat of a "RRRRRRRRRRRR" tone when the engine is running (a little like the sound of a power steering pump that is low on fluid, but less prominent) that wasn't there previously (and it developed maybe 2 weeks ago). I thought initially it was the AC compressor, but it still makes the noise with the belt off. My mechanic (who I've known for 30 years) is very knowledgeable and trusted, and he changed the oil to the 0W30 and initially thought it made a difference, but as he drove the car for a few days while I was away, he thinks he still hears it, so even he isn't 100% sure what's going on. I am meeting with him in a few days because I have to decide whether to have him take the front of the engine apart to inspect the timing belt assembly (he performed the replacement last year) to see if the noise it coming from there (he does not think it is, he thinks it's coming from the bottom end, but is not certain). He started the car on a lift and used a stethoscope on the oil pan and told me that he is very familiar with the sound of "rod knock" and is fairly certain that is at least part of the issue in my case (hence the thicker oil). If this is something catastrophic I'm going to have to trade this car in and start over (before something lets go). I really and truly do not want to do this, as I am committed to this car (as previously stated, I recently installed new shocks, brakes, alternator, replaced a few leaky gaskets, changed the spark plugs, engine and trans mounts, trans and PS fluids and likely a lot more I'm forgetting) but at some point this is not going to make financial sense. I mentioned the VCM issues to my mechanic, but if I understand that correctly- it manifests itself in the upper engine (piston / rings) and not the bottom end.
I'm open to taking the car to another mechanic who might be particularly knowledgeable and experienced with this engine specifically (I'm in NJ). My wife is scouring local dealerships online for a CPO 5th Gen Ody- but I don't want to get rid of this car unless it's really something dire. I was hoping for suggestions that could perhaps help my mechanic focus his search for the cause.
Thank you to all of you who are trying to help me! Regardless- it's a silly car issue, and is a problem that money can solve- so not something important (in the grand scheme of things).
Happy New Year to ALL!!