I agree - Yahoo's data service is just not worth spending any time on using as a real trader. As a trader you should never be wondering if your data service is going to work today, or will retain the same functionality as yesterday.
In terms of what I settled on... For my quant/TA trading systems:
NxCore (for live US equities), Norgate Premium Data (for daily/EOD) and Interactive Brokers (as part of my order placement systems).
As a backup live terminal, and when I want to look up exotic information, I use Metastock Xenith (which is a slightly cut-down version of the Reuters Eikon product).
On the fundamentals side I'm having a look at Portfolio 123 but may have to look at a S&P Capital IQ subscription at some stage.