Well I feel like I'm qualified to jump in here now.....
I just woke up (at 1pm) after spending ALLLLLLLL NIGHT sitting in the hospital waiting for my nephew to be born. He's here!!! Everyone is doing great!!!! I saw my sister a few minutes when I first got there (that was BEFORE she got the epidural....lovely sight

) and then I sat in the waiting room the whole time. He was born at 6:17am and about an hour later we got to go in and see them for a few minutes. We couldn't hold him, just look at him, and was run out of there after 10-15 minutes. (My sister was induced because her BP was too high....wasn't completely planned.....and they wouldn't let us stay because they didn't want her to have any excitement so her BP would come down). I stayed because I wanted to visit with my mom, who lives 6 hours away. Otherwise, I wasn't really needed there. There were about 15 other family members there.
I'm apparently rambling......
I say have a good talk with your sister. Most likely you will be sitting in the waiting room all day and I'm afraid you will be upset/thinking about/kicking yourself about missing rush. She will be on the goofy meds (my sis was, and it was a normal delivery). I would say the best time to visit would be the next day or two when everyone is more awake and alert....and the weeks afterwards when the baby is REALLY awake all the time. Also, (don't flame me for saying this....it's my opinion, not fact) the aunt isn't the highest person on the visitor priority list. You've got the grandparents and great grandparents who get first priority on holding him/her, etc.
JAM has good advice also....do what YOU WANT, not what you think you should do. I've fallen into that trap many times with my family, it's a hard one to avoid. Talk with your sister, think of some really thoughtful things to do for her after the delivery (my mom brought my sister Krispy Kreme donuts from OKC because we don't have them here...), and do what's right for you.
Good Luck!!!
(dang I type alot when I haven't had any sleep!!!)
PsychTau