It depends. I’ve put over 200 hours into Starfield and didn’t experience any dull or boring parts. But I noticed them.
It’s an old-school game with decades old mechanics, which happened to push all the right buttons with me. But others find it’s boring.
Loading screens for nearly every door. In New Atlantis you can jump from the highest building and glide with your jetpack back to your ship. But taking the elevator and the train gets you two unnecessary loading screens. That’s just not 2023 game programming.