I’ve tingled that problem before.
The solution isnt “intelligent artists” in as much as it would be a sane database-cleaning script.
Too bad sqlite doesn’t know stored procedures, or else I’d have written that in a jiffy. If you do a search, you can find the some SQL statements that I’ve played around with in the past, here on the forums.
Too bad I don’t know any scripting, because I’d really like this feature too.