I always go with accuracy over artistic.
Its all about personal preference, yes (my personal preference being realism), but honestly, Ive heard much more negative comments from modelers on exaggerated weathering than from a kit sticking with accuracy. In fact, most negative comments Ive heard about accurate builds stem from the fact that the commenter/s were mostly unaware that the finish was actually based on photos.
And yes, one can "overdo" weathering. Ive seen a low-viz F-14 kit uniformly covered with patch up paint work (like the patchwork has become the camo itself), and quite a number of pre-shaded, post-shaded plane and helicopter kits sporting uniformly faded/oxidized paint. One look and you know its overdone.