Foobar is excellent, and a model player in many respects. With some time and effort, you can make it truly great.
But really, if you're looking for the all-in-one end game player, that absolutely has to be JRiver Media Center 18 (19 is on the way).
jRMC is pay to play, unlike Foobar. Also unlike Foobar, it's well configured out of the box. The JRMC iPad app is an absolute dream, the sound quality is as good as you could possibly hope for, the compatibility is unrivaled, and the support is instantaneous. Jim and Matt make the whole thing, and also administer their own support forum. Problems are solved in hours, feature requests are listened to and addressed by the actual people who write the code, and their hardware support is absolutely bleeding edge. You can configure it as simply as you like, but there's always more to dial in under the hood, if you like to make changes.
The tagging and organization in JRiver is comprehensive and granular, which helps organize large libraries easily.
It's constantly updated, and updates are really good. I'm usually excited to download them. Your purchase price buys you all the upgrades for the life of a given version, and anyone who buys it now gets MC18 and MC19.
I've used everything listed here (only mpd on *nix) and prefer JRiver to every other solution on every other platform. Every cent of your investment goes into a good developers pocket, and you get a world class product for your money. Can't beat it.