I am new to modding and facing similar issue. What I realized is that since Z axis rotation is not supported, using combination of X and Y does not always work. I think the Block State JSON file always apply X-axis rotation first before Y-axis rotation, but I needed Y-axis to be rotated first before X-axis rotation to get to the texture face I need. Is this a bug or an intended behavior? Am I missing something?