Definitely do not use aperture priority mode, it will make your life absolute hell trying to correct changes in brightness/exposure over the duration of the "holy grail" portion of the timelapse (this is called "flickering" and IMO it ruins timelapses). qDSLRDashboard is probably the easiest way to accomplish the auto-transitioning of exposures and aperture for the holy grail timelapses, you can tell it to ramp aperture first and then exposure next that way you isolate different settings and optimize the quality. You want fast exposures during the day to freeze motion, this gives timelapse better smoothness when there is more light and you can run at a faster framerate, it makes motion in things like water or clouds, breezes blowing trees/flowers/bushes, etc to be clearer and cleaner during the timelapse. Then during the transition to astro dark you can ramp your exposure because lighting of the foreground will dissipate, you won't care as much about freezing those elements with fast exposures because you simply can't see them. I've done quite a few timelapses and holy grail ones, especially sunset to into the night, I've done a few sunset to sunrise ones as well. This one is probably my favorite, back with Comet Neowise, we had a great sunset this night over the lake and then Neowise came into view with a good reflection in the calm waters. We also had good airglow with some thinner clouds that highlighted stars in the Big Dipper, I utilized my slider rail with no rotation of the camera:
https://youtu.be/d1j...?feature=shared
I liked the result from this Bryce Canyon day to night transition because you could see the earth shadow race across the sky during twilight, golden hour at Bryce is incredible for Holy Grail timelapses:
https://youtu.be/2Y-...?feature=shared
I've got quite a few timelapses on our youtube channel:
https://www.youtube....raphy796/videos
LRTimelapse is a must, it's the easiest and most complete timelapse software for this, you'll also need Adobe Lightroom as it's kind of a two-in-one editing suite that utilizes functions in both to smooth out the frames. Some tips I have would be:
Do not touch the camera once it's started, do as good of planning as you absolutely can in terms of framing and orientation prior to starting, then once the exposures are going you absolutely do not touch the camera at all until you are ready to end it. A dummy battery with a big battery brick is 100% necessary, especially if you do twilight to twilight sequences and temps are cold. Slider rails and rotators are fun, but exceptionally difficult to get running correctly and take tons of practice to understand how the camera is going to move and cover views over a sequence. Like I said above, ramp order should be ISO-> Aperture -> Exposure for a Holy Grail sequence, I preferred to keep my ISO the same at the invariance point for whatever camera I was using to keep it a bit more simply, so I always ramped aperture and then exposure.