Like most of Apple's software, it's extraordinarily annoying. It may or may not surface what you searched for, it may or may not deep link into it, it may or may not be entirely wrong. Just a huge waste of time, "free" is too expensive.

Most of those issues are with individual streaming providers messing up their implementations of the announcement apps, or showing how terrible their own catalog is (e.g. Hulu wanting to play the Spanish version of the Mentalist) but there is definitely room for improvement- it should remember properly which provider you watched a series instead of constantly reverting to what it thinks is best which is based on the bad data from the other apps.