The way I thought it might be done is to use Roon Radio with Valence as usual, but once a Track is chosen insert an additional check of the local library to see if a better version is available.
Valence uses the catalogues of all connected streaming services to suggest music already. They’ve already done the hard part.