I'm glad Fooyin got an honorary mention, because that's all I need:

Update: After reading through many comments, a lot of people mentioned their affinity for foobar2000-style players, and fooyin came up as the most frequent suggestion. I haven’t tested it, but it seems to be very popular. If you want even more options, fooyin comes highly recommended by a lot of people.