Depends on the game, but overall yay. Some of my favorite games are Breath of the Wild, Tears of the Kingdom, and Red Dead 2. Open worlds really let you immerse yourself and get lost in the game, especially if you limit fast travel.
I recently played Jedi Fallen Order for the first time, and I was a bit shook at how "level-y" the worlds felt. I wouldn't say open worlds have ruined traditional games for me, but it sure is jarring going back to them.