Having opened this issue with Apple support, I got it back from the engineers that this "clever" search result is the correct intended behavior in Mavericks and that there is no preference available for users to adjust it.
I raised the point that if you search for a song that was covered by multiple musicians, your result is just the song title over and over again without other helpful charicteristics.
There are two sollutions that Apple can offer.
Make this metadata result "name" optional (What they should do)
Add other metadata results as option columns. If we know the artists in the result, it's not as bad. It is still not how a file manager should behave.