I've mostly stuck to SteamOS myself, since trying to install Wine manually (on Ubuntu) to run a couple of Windows apps went alarmingly badly. Command after command, and I could still only get it to start as root.
There's definitely still room for a distro that loads, scans your drive for a Windows partition and Windows apps, and just lets you run them with minimal fuss.