Congratulations on the birth of your nephew.
Having seen several births and judging by my wife's reaction I think on a scale of 1-10 childbirth is about an 18 pain level. But it is indeed a sight to behold, nothing like it. My best wishes go out to the Mom and baby.
Now you have a new purpose in life, spoiling him. Hurry, before you know it he will be all grown up.