We know that the basis vectors $\{\textbf{e}_r,\textbf{e}_{\theta},\textbf{e}_z\}$ for cylindrical coordinates and the basis vectors $\{\textbf{e}_x,\textbf{e}_y,\textbf{e}_z\}$ for Catesian coordinates at a common point in space are related by a rotation described by the following equalities $$\begin{cases}\textbf{e}_r=\cos\theta\textbf{e}_x+\sin\theta\textbf{e}_y\\\textbf{e}_{\theta}=-\sin\theta\textbf{e}_x+\cos\theta\textbf{e}_y\\\textbf{e}_z=\textbf{e}_z\end{cases}$$
Let $\textbf{v}=R\textbf{e}_r+\Theta\textbf{e}_{\theta}+Z\textbf{e}_z\in \mathbb{R}^3$, then from above relationships we have $$\textbf{v}=R(\cos\Theta\textbf{e}_x+\sin\Theta\textbf{e}_y)+\Theta(-\sin\Theta\textbf{e}_x+\cos\Theta\textbf{e}_y)+Z\textbf{e}_z\\=(R\cos\Theta-\Theta\sin\Theta)\textbf{e}_x+(R\sin\Theta+\Theta\cos\Theta)\textbf{e}_y+Z\textbf{e}_z$$
However, we know from coordinates conversion that $\textbf{v}=R\cos\Theta \textbf{e}_x+R\sin\Theta \textbf{e}_y+Z\textbf{e}_z$, which is different from above expression (except the $z-$ component). Why is this so?
This seemingly "inconsistency" between coordinates conversion and basis conversion is also refelcted by dot product computation: $\textbf{v}\cdot\textbf{v}=R^2+\Theta^2+Z^2$ under cylindrical coordinates $\{\textbf{e}_r,\textbf{e}_{\theta},\textbf{e}_z\}$, but it is clearly not true in Cartesian coordinates because the legnth of $\textbf{v}$ is in fact $\sqrt{r^2+z^2}$. Does this mean that the dot product (or length of a vector) derived under the cylindrical coordinates are different from the ones under Cartesian coordinates?
Could anyone point out the subtlety behind above "inconsistency" for me?