TV shows are of course centered around cases where the ID of the murderer is harder to prove. That's just basic storytelling.
[1] http://www.npr.org/2015/03/30/395069137/open-cases-why-one-t...
Moreover, it's tough for a interpersonal conflict to rise to the level of homicide without someone else noticing.
If you can't accept that police will often know who committed a murder without having sufficient evidence, you're denying the messiness of the real world.
You also forgot the bizarre way TV/Movies compare law enforcement agencies as well:
1) Local cops are the smart ones - FBI are the idiots
2) FBI are the smart ones - Local cops are the idiots
3) CIA/Gov Agents are the smart ones - FBI/local cops are the idiots
4) Local detectives are the smart ones - CIA/FBI/Gov agents are the idiots
It's kind of funny to see how each agency is either propped up or summarily demonized - and it changes in every movie or TV show.
You don't realise the massive power of the American cultural imperialism. It is a steamroller: most European people have a better knowledge of the police and justice systems of the USA than of their own country!
(And that's not only about fiction but about the news: we also know better the political system and political life of the USA than the ones of our neighbouring countries. We still know our own better, luckily :-) )
The official police are always bumbling morons and most crimes are solved by a quirky amateur with a personal connection to the case.
Why don't you guys just hire better police? Maybe Sherlock Holmes, Lord Peter Wimsey, and Miss Marple should be running Scotland Yard.