You've done well to resist the urge to buy something that looks flashy but in reality would be totally useless. The EQ6 will serve your needs for years to come. I haven't used the EQ6 personally, so my experience may or may not translate well for you. Before my stroke I was using my CGEM-DX with just a camera on it. The CGEM-DX came in essentially two parts: the tripod and the mount. Using the solar noon method I worked out and drew a north south line in my courtyard where I wanted to use my scope. I took my tripod only outside in daytime and lined it up on the line and found a chink in the pavers to put one tripod foot point into and pivoted it around that point until it was NS aligned then using white crayon I circled each foor point so I could put it in the same position everytime (later I used a masondry drill bit to put dents in to paving so I could place the tripod by feel.
Now my mount sits on top of the tripod in a hole and it has two handscrews that can be used to hold it in position against a fixed pin. Now the mount is an EQ and has two movement axes so I disengaged their clutches and made sure they were both at a "zero" position (at this stage the dovetail is roughly pointed to the celestial south pole. If your mount doesn't have markers to align the axes at a zero point you can just eyeball it, re-engage clutches then place some masking tape across the pivot join, draw a line on the tape across the join then cut the tape along the join. This gives you a marker you can always reliable return the mount to in the future. With the two axes "zeroed" I then used the hand screws and compass to get the dovetail as perfectly aligned on a north south line as I could make it. I was then able to remove one handscrew and add a nut to it and put it back in place and "lock" its position firm with the nut".This means that hand screw is hard against the fixed pin on the tripod. I could then undo the other handscrew and lift the mount off and put it back on the tripod and turn it so the locked screw is against the pin and when I tighten the loose handscrew my mount is now firmly in position and NS aligned. Adjusting the evelation angle I used a digital level meter.
The upshot is I had physical positions for the tripod and mount to reliably set it up every time aligned to the celestial south pole. So no fine tuning in the dark. I could use this as the alignment for goto to work for widefield visual, but for photography I would use 3 star alignment with the camera weight balanced for the region I wanted to photograph. I would occassionaly test my aligned by taking a 30min exposure at the zero position and I could see the star trails were circling around the center of the frame.
At the end of a session I would get the mount to park itself back at the start zero position, turn it off and dismantle ready for next time. It was too big and heavy to keep assembled so I had to do this each time but it was dead simple. I think at this point you might have some misconceptions about tripods/mounts, but rest assured you made the right purchase. Do some setups in the day, reading the instructions carefully. Once you start using it you'll understand which adjustments/alignments only need to be made once if you're only using from the one location. be patient and dont worry, the EQ6 is possibly the most widely used mount so help is never far away to help you out.
Some starting tips, accurate alignment really is important so take is slow and get it right each time. Balance is important too, for photography get all your gear on the mount, disengage clutches and point it to the region of sky you want to photography, NOW balance the setup in THAT position before you use the handcontroller star alignment. If you're doing a few minute exposures this should give you nice round stars.
Plus later as money and interest permits you can look at a scope (or scopes, the EQ6 will accommodate reflectors and refractors with ease), a guiding package and other things you might learn about and take an interest in. For now an EQ6 and a regular camera will get you great shots of what's up there and be ready to serve you well when you are ready to progress.
Of course be warned to expect storms when your gear arrives, its a law of physics
