I think the bot is fine in principle. The YouTube web site is fucking terrible and it’s nice to introduce people who don’t use automatic redirects or 3rd party clients to an alternative.
My problem is that it would offer only piped.video links. We don’t know how long the piped.video instance will work, but well that’s the case for any instance. Ideally a bot would provide at least two links - piped and invidious, and maybe cycle or randomly choose instances. Perhaps under a spoiler tag.
Of course it’s up to community mods to choose, but I think bots like this or the tldr bot provide value even if they can cause that “Reddit moment”.