It depends entirely on their personality and upbringing
Both of mine are very passive and easily pleased. There is occasional crying but it's shortlived.
I thought I had got to the point where sleep didn't matter any more but after having Jack for a week I remember what proper exhaustion is like ;-). It's easier second time around but still a mental and physical strain in the beginning.
Good luck with yours.
Simon