First, most racing engine builders will tell you that the most important valve event is exhaust valve opening. Why? When the exhaust valve opens, the first thing that happens is you stop making power. The longer you can keep the exhaust valve closed, the longer you can burn the mixture in the cylinder. This means you are still building cylinder pressure. This helps in two ways. First, you make more power (assuming you did a good job of filling the cylinder). Second, the higher pressure in the cylinder helps clear the cylinder during blowdown. Blowdown occurs immediately after the exhaust valve leaves the seat. The bulk of the pressure (and spent gasses) leave the cylider very quickly at this time, leaving the piston to sweep the cylinder clean during the rest of the exhaust stroke.
On a turbo engine, blowdown is slower. The exhaust gas runs into a restriction ( the turbine ) on its way out. Also, the volume of exhaust gas we need out is very high. The N/A gasser can dump its volume faster and may get away with a late exhaust event, but I think we should define what we mean by late and early first. The helix 2 opens the exhaust valve at 39 BBDC. In the gasser world that may seem late, but RPM ranges are usually higher.
On the intake side, lobes that make good power should obviously help feed the cylinder well.To this end, they should move the valve as quickly as possible and duration in the higher lifts (.200+) should be as long as possible without sacrificing overall system reliability. To that end, the Cummins has some features that help this. The cam core diameter is one as is the diameter of the followers. Some of them have fairly high-ratio rockers, which, when combined with proper springs will give good results.
Even at idle, the Cummins has some pressure on the intake manifold over atmo. Ever remove the boost pipe to the manifold and feel the volume air rushing out when the engine is idling? A turbo engine fills the cylinders fast. Just a point I think can get lost on anyone with a gasser background. Dont get me wrong I am a old gasser guy myself. I tuned a alcohol funny car for years before moving on. Heck my old ass worked at Harry Eberle's Super Shops in the early 80's if anyone remembers them??
Finally, lobe separation helps get overlap duration where it ought to be as well as placing valve events where you want them. Making statements like
""wide lobe separation cams are doggy" means that whoever came up with the grind didn't pay much attention to valve events.
The reality of most of the cams I see guys talking about on diesel sites is that they will probably have very peaky, somewhat disappointing torque curves and fairly high EGT's. They also will sacrifice engine efficiency relative to how much fuel it takes to make a given amount of power. And unless I missed something, that basically undoes what a diesel engine is all about.
As far as horsepower, it is a function of torque and RPM. If you make the torque and spin the engine high enough, you will make the power. Cam the engine for an unrealistic RPM range and you will be disappointed by the results.