John,
I had to laugh. Weathering is just one of those hitches for me as well. I love seeing very detailed weathered equipment but had a hard time doing it as well on my HO projects. Then like you I bit the bullet and did it and enjoyed it as much or more as any other building aspect.
Well it has reared its ugly head again. On my new first scratch built loco I want it to be pretty and shiny. Spend all that time making it how can you “ruin” it. But I know I want it that way so to ease my tension I will get it all shiny and new, take a “builders” photo of it, then put it into service and weather it and make it look like the work horse that it was.
I know once I start I will love it all the more.