It's all the above, lol! Tight plus kinda flaky in spots. I use hyaluronic acid daily or Buffet by the Ordinary and an oil over it after it sets, or a light lotion that isn't greasy.
At night I wash with gentle wash - Cetaphil and always moisturize with a heavier cream. I've tried many from CeraVe to Chanel, can't find one that truly works. I use a retinol by the Ordinary followed by rose hip seed oil 1-2x/week.
Depending on the oil, it might not (and is not, in your case) be occlusive enough to "seal" your daytime routine.
As for night time, Cetaphil may indeed be drying your skin out. Which heavier cream are you using? Also, retinol is definitely drying.
You need a hydrator + an occlusive. Also, the hyaluronic acid can't actually add moisture to your skin, it just tries to bind what there is to your skin. aka if you use it in a desert you will make your skin even drier.
Have you tried sheet masks for a quick hydration boost?
After cleansing, use your hyaluronic acid. Then add your rosehip oil, and put a sheet mask right on top. Don't wash it off after. Put your heavy cream on. Go to sleep. Rinse off with water in the morning and add your light cream. See if that helps.
The oil can go on after your sheet mask as well, but there are penetration enhancers in the sheet mask serum that will help push the oil in deeper if you put oil on under the sheet mask.
Personally, I like the My Beauty Diary masks. Very clean ingredient lists, I have eczema and it doesn't cause/exacerbate flares, and they're relatively inexpensive. Try the Bulgarian Rose / Damask Rose; Royal Pearl; Bird's Nest.