Would you put an LS1 into your Land Cruiser? Most people would say yes without any misgivings of peaky power, etc. The truth is that the LS1 is a more peaky engine than the Northstar.
Check out http://www.gmpowertrain.com/engines_cartruck/northstar/46_main.htm
and take a look at the torque curves for the N*. It's not as peaky as most people seem to think.
N* pluses: fuel injected, high tech, clean burning and efficient, light weight, bullet proof bottom end.
N* minuses: bell housing adapter required, electronics are a B@#$%, comparatively expensive, routing water lines more difficult, possible fitment issues with water pump.
With either the N* or the GM 6, you'll be making peak torque around 4000-4500 RPM.
Given the choice, I'd probably go with a fuel injected Cadillac 500, though. It's only ~50 lbs heavier than a small block (80lbs lighter than a big block). I've heard of 500's running pre-oilers being able to light up the back tires of dualie pickups with 800,000 miles on the clock. The engine is also quite efficient.