Agreed, in my little experiment, I made it a point to do little everyday towards my goal, if not a lot, with no pressure on how much I achieved in a day. The idea was to build consistency. It's surprising how well this approach worked for me. Just filling in the "What did you do today?" bit kept pushing me forward and kept me motivated.
I think the whole "be-the-hardest-worker-in-the-room" holds good only when you're so into your work that you forget what time it is. Otherwise, it definitely becomes a chore and a health hazard.
I've found that achieving goals where nothing changes can be pretty anti-climactic. An example is weight loss, where you reach a normal weight or whatever goal you have and afterward, either you keep doing what you were doing or you'll gain weight (unless you do something else that changes calories in vs. calories out).
Taking a break from goals is also a judgment call and not necessarily something to be ashamed of the way motivational YouTube videos will say.
It's up to you what you want to do with your life. If you set a goal but wind up giving up on it, hopefully you can still learn something from the experience. Beating yourself up or telling yourself you are a "quitter" or a "failure" does not help.
Motivational books and videos will basically idolize being a perfect robot that never relaxes, never takes time off or does anything relaxing, and in many cases neglects basic things like spending time with family, sleep, etc. I think that's unrealistic. I need something sustainable if I'm going to make a lasting change in life. But that's just me.