I'd like more info to give a better answer. However,
'Problem is, overnight wind will likely drop to nothing while boat is moved in whatever direction the water moves..." that's normal at an anchorage but if you mean it is in a tidal area, then you can always set a second (i.e. additional) anchor. The anchors can be set at a V-shape to the bow, or 180 degrees apart.
I like the SARCA, Rocna, Bugel and similar hooped anchors; their reputation is better for re-setting and holding in more types of seabeds.
To solve paranoia when anchoring overnight, the answer is practice and practice, and ideally with calm-ish conditions and with the extra length of chain and/or heavier anchors recommended. Anchor overnight when there is no cold front forecast, when the winds are predicted to be below 10 knots all night, etc, so you don't expect to have testing conditions and stress.
I'd recommend having a second anchor, and one of them having about 15 metres of 8mm chain. That way, you have adequate chain rode and nylon, you have a second anchor as 1) back up and 2) at a different angle (60 degrees apart, or 180 degrees if tidal reversals), and practicing in benign conditions, and having a cold beverage in the evening, enjoying the sunset, calming your nerves and taking it all in, that there's no adverse wind or currents affecting the boat.
There are also plenty of articles and chapters in books about the various techniques/methods.
