I hate timers in games but I also love them. I don't deal well with time limits in things like RTS timed missions where you have this amount of minutes and have to survive or win in that time frame. I also don't like turn limits in card games, where you have to win or survive in this amount of turns. Because in those games cases, it doesn't add anything to the game, it is just a stupid limitation in some missions/quests/levels that will just make you repeat the mission/quest/level over and over until you beat it.
Now in games like RPGs, it adds to the tension, it usually explicitly tells you what the consequences are if you don't do it in time, and the time limits are usually fair, it is a mechanic that works well in the game it is included (since the game is made around it), not a "let's make this level harder by adding a stupid time limit" added to the game just to make a part of it harder (like, most, or all of the game isn't built around this limitation).