Badly implemented motion controls can feel awful, as shovelware can certainly demonstrate, but guess what, badly implemented standard controls can suck tremendously too (hello, "hold L3 / spam X for running" among many others) and those can happen in any game. But for some reason those get a free pass even if they're generally despised.
There's a great deal of games with well implemented motion controls, some to do standard actions, such as shooters, sport games (golf was the biggest winner there) or racing, some to create unique experiences, such as the skill-based Kororinpa games or Let's Tap, and there are way more than people give credit for. Mostly because that would mean people would have to actually give a damn and try to both look for those games and spend a few minutes to understand what and how the game expects you to move the controller.
Well implemented motion controls can feel so natural that you often forget how much they can improve the overall experience until you have to play something without them. Case in point, the most basic example would be Aiming Controls.
The Nintendo Switch got time ago ports of Resident Evil: Revelations 1 and 2. They came with the added feature of gyro controls, so you could move the controller or the system to help you aim. They were really well received overall. In fact, is one of the most requested features when companies port shooter-related games to the Switch, some games such as Doom got gyro controls added to them post-launch, even.
Recently, Capcom also released Resident Evil 4 for the Switch... And it's a bare bones port without any improvement. People have been pretty vocal about pointing out how disappointing is this port, some people arguing about the price (which is insulting, because it costs more and they didn't add anything), but the biggest complaint about it was the omission of motion controls, which many expected and among many of the comments there were praises for Resident Evil 4 Wii Edition as the best version still thanks to the motion controls and how much better they made the game, even if it still gave you two other non-motion control schemes.
RE4 Switch could have been the new best version (HD, Portable & on a big TV and with the Wii motion controls added). But what we got is a giant wasted opportunity.
While I perfectly understand not liking, or wanting motion controls on everything (they shouldn't be shoehorned into every game, and offering different control schemes is also recommended), I also think there's something to be said about the weird fear some people had/have for things that are different to what they're used to, to the point of having this vile reactions and condemn any implementation of motion controls even if they're central to the game's design.