Generated normalmaps will never be as good as handmade ones (unless actual 3D data is used to generate them).
I tried using generated normalmaps multiple times but the result was never something I'd call good:
(click for full size)
But I have to say that crazybump produces useable results (although I'm 100% sure they've used an image which works well with their generator to show in the video)