Appearance can indeed be enhanced at the cost of CRI. There is a video showing how color appearance can create different effects by altering spectral characteristics of the illuminant and shows various items, including some colorful vegetables, with differing spectral characteristics. Check out the examples around 5:40 in this video.

The main area where different lighting is used to create different effects is the IES TM-30 work. More technical details are discussed here and here.

There is also this research that studies how to optimize for higher perceived color saturation. In particular, GAI (Gamut Area Index) is especially applicable to retail displays.

But the definition of color rendering by the CRI is limited, and many research papers have already shown that high CRI alone is not enough to reflect the true color of the products in some special applications, e.g. retails/shops, where the subjective characteristics such as attractiveness and preferences would be more useful. Progresses have been made in recent years to develop new color quality metrics. Among many metrics, gamut area index (GAI) can be a useful supplement to the well-established CRI in ensuring color saturation and satisfactory perception of the object color. A light source which has enhanced chromatic saturation (chroma) can serve to increase the visual clarity...