So what we get in Death Note is a calamitous lead character that has to make middle schooler mistakes, that then suddenly develops some smarts: It's the only way to make the net grow close early on, but then withstand a few more books. But even with the whole second kira twist and all of that, it's very hard to make the story coherent, and kira not get caught very quickly after making the mistakes that are mandatory to make the story any fun. Ultimately, Ohba has to rely on making L also act in pretty suboptimal ways, just to make the first arc of the story last long.
Which brings us to how Death Note is a good example of why it's so hard to make realistic crime stories: It's very difficult to make a story long enough to not be trivial, and yet have the criminal get caught in the end: It's far easier to make a very good criminal or a hapless one than to make one that will move the story along at a good pace.