Tilted rotation of weakly deformed and triaxial nuclei