USUM makes Larvitar available quite early, so I decided to give it a spin in my Ultra Sun run. After all, Tyranitar is awesome, isn't it?
...unfortunately, Pupitar decidedly isn't. At all. It outsped nothing, kept getting KO'd by stuff, and didn't hit back particularly hard. Pupitar's power curve drops like a rock relative to the opponents from level 40 or so onwards, and unfortunately, it evolves as late as 55. That means you're unlikely to have a Tyranitar before Mt. Lanakila, which means dragging Pupitar through Poni Island. It was constantly underleveled, so I had to put it in the lead position very often. There, it tended to eat a coverage move to the face and faint, getting no XP at all, which only exacerbated the problem. Its level-up moveset is also not really that great. True, it gets Rock Slide from the get go, which is a nice and powerful STAB move, but it's inaccurate and doesn't quite have the oomph to KO stuff in the mid-late game. At that time, opponents definitely have the oomph to knock Pupitar out.
So yeah, the road to Tyranitar is long and painful, and best undertaken using Exp. Share in the postgame. Same goes for the Dratini line, which really doesn't pull its weight until Dragonite. I had similar experiences with the Ralts line in XY, but at least Kirlia has the decency to evolve at level 30, roughly halfway through the game.
As someone who also used the larvitar line in USUM (although mainly because I love Tyranitar's design so much) I agree that it is horrible to use... Until it becomes Tyranitar anyways! Once it did, it destroyed so much. Totem Ribombee? Take a super effective hit, do amazing damage, and let Sand stream wear it down! Gladion? Instakill to Crobat and fire silvally! Zoroark too, because even if it has focus blast (though I do not remember if it does) it takes it just fine! And if it doesn't, it won't do much to Tyranitar at all! Accerola and the flying elite four member are basically defenseless, except for the flying one if she has hawlucha, but that's what switching is for! Hau? Good bye Alolan Raichu, Jolteon, Flareon, Noivern, Inceneroar and Decidueye (maybe)! It also fares well against the many RR grunts and evil team leaders crobats you'll see in RR castle, as well as Cyrus' houndoom, Lysandre's Pyroar, and more!
Anyways, I have some Pokemon I myself want to say how disappointing they can be.
RBY: Chansey. Bit of a surprise considering how good it is competitive, I know. To be honest, I'm only mentioning Chansey for this gen because in other gens, you'd expect it to be bad. You'd think that healing, 250 HP, and 105 special would be awesome. Ice beam and thunder wave too?! What's not to love?! Well, it's 5 defense holds it back quite a bit. I can name SO many bosses that gives this trouble. Such as... Koga, every rival battle, Giovanni (final), Bruno, Lance, and those are just EXAMPLES! Sure it gets thunder wave and blizzard, but you won't bet blizzard until REALLY late, and thunder wave is far better competively than in-game. You may think Blizzard helps it against Lance, but it's too slow to actually get to use it much, if at all! So yeah, it may be rare, and it may seem promising, but it's really quite bad. If you want a great normal type for gen 1, use snorlax, and if you want a good rare normal type in gen 1, use Tauros!
USUM: Noibat. If you want it to actually be around the usefulness of your other party members, I hope you're doing crazy ways of playing the game like me! ... Anyways. As a Noibat it's about as good as a freaking unevolved Cleffa is, it does absolutely horrible! Even when it becomes Noivern, it's still not all that good, as by the time you can get one, it'll be level 48! ... What boss does it actually fare well against, even as a Noivern? Well unlike Pesudo Legends where they wreak havoc at their final form, this one doesn't! Sure it gets good stab and decent stats, and it's actually a good Pokemon. But it's what bosses the game pits you up against that makes things bad. Totem Kommo-o, Ultra Necrozma, Totem Ribombee, several of the trainers in Mount Lanikilla, Molayne, Olivia, Lot's of RR and more!