I try to watch these modern detective shows but my attention usually wanders. The clues aren't particularly interesting and the cases are often resolved not in an intellectual manner as with Columbo, but because the protagonist is Superman and somehow just knew everything. Shows like The Mentalist and Lie To Me were like that anyway.
I don't think that those modern shows are terrible, they just look bad compared to Columbo. It was a virtual miracle in the first place for a television production to be produced at a high level like Columbo. I think it was the "wheel" format that we have to thank. The masses were placated with MacMillan and Wife and McCloud and people like us could get Columbo once a month. The stories and productions were too complex to be made on a weekly basis. And I don't think that a national audience wouldn't have gone for it every week either.
The good thing about today's niche tv markets is that we do get a lot of choice. You might like Mystery Woman or McBride on the Hallmark Channel. And of course there are the classic Poirot and Miss Marple series available on Netflix. If anyone else has a favorite please share it.
I can't watch watch those shows either, especially the NCIS shows. To me, they are just a tad to unrealistic, not in the sciencey aspect of the show, but in the fact that real CSI people don't do anything resembling what goes on on those shows and neither do the NCSI people....especially the Los Angeles show. The only show I can really get into is Elementary, mostly because of the acting of Johnny Lee Miller and Lucy Liu is pretty good and they feed off of each other really well.