everyone has very different experiences with night time EC. to some extent you just have to try and see if/what works for you. and it's likely to change (and so much of parenting does) as baby grows and patterns change.
my experience is that i only night time EC'd my 3rd child. and she slept better at night than the other two, and in hindsight i wish i'd tried at night with the older two. i think she slept longer/better because when she did pee she was able to completely release her bladder, which kept it emptier for longer. she also didn't nurse as much as a result, thus didn't need to pee as much. but she also demanded to be night time EC'd - she'd literally kick me in the stomach when she had to pee
so there was really no avoiding it. but she started often going all night w/out peeing when she was very little - like 2 months, and was consistently dry all night by probably 6 months or so. i haven't bothered to diaper her at night for a loooong time (she's now 20 months and has been an EC grad for a few months now). she also always fell asleep right after she peed. sometimes nursing, sometimes not. in fact sometimes she fell asleep *on* the little potty the second she finished peeing
we just kept a little potty and spare diapers bedside, and when she let me know she had to pee i'd take off her diaper and potty her. if i didn't wake up quickly enough to catch the pee, i just changed her. we kept a bucket by the bedside that i tossed the dirties into. in the winter i put a microfleece 'cozy' on the little potty so the plastic wasn't cold. i pissed her off a few times with a cold potty seat before i figured that trick out
i'd say try it - it'll either make your life easier or it will suck
either way you'll probably feel strongly one way or the other. and if it sucks, don't worry about it. try it again sometime down the road if it feels like a good idea.
sleep is super important, in my case it helped bank us more sleep. but that's not the case for everyone, and you need to do what keeps everyone well-rested.