Simple answer: PokémonDB pages assign a color to base stats depending on their numerical value, which estimates how good a base stat value is in general.
<30 (Red) - Very poor
30–59 (Orange) - Poor
60–89 (Yellow) - Mediocre
90–119 (Light green) - Good
120—149 (Dark green) - Very good
150+ (Teal) - Outstanding
Nuanced answer: It may sound dissatisfying, but it's hard to say whether a stat is "good" or "bad" just by looking at the number because you need to consider two very influential factors:
Good for WHO? What are the other characteristics of the Pokémon? Abilities, typings, and movepools will affect how the stats can be used. Regigigas' attack and speed look promising at first, but they're ruined by its awful ability of Slow Start.
Good for WHAT? The battle format you're playing will influence who you'll be standing up against. Doduo's base 75 speed is very solid in Little Cup, where only unevolved species are allowed, but that's far from impressive in most other formats without that restriction.
Let's take a closer look at Tinkaton. It's true that 75 base attack is nothing special compared to the dozens and dozens of Pokémon whose Atk or Sp. Atk exceed 120. But base stats aren't the whole story—Tinkaton has access to a few perks that help it retain competitive relevance:
- A 160 BP STAB move in Gigaton Hammer
- An amazing typing with 9 resistances, 2 immunities, and 2 weaknesses
- Access to a variety of utility moves like Thunder Wave, Stealth Rock, Encore, and Knock Off, which can cripple opponents without directly dealing heavy damage
As a result, Tinkaton can pose a threat even without an outstanding base attack if used in the right role and format. In Smogon's tiering system, it currently sits in UnderUsed, where it's typically used as a wall or support option. 75 attack isn't great, but it's good enough for this context.
Let's look at another Gen 9 Pokémon that's used defensively: Wo-Chien. On paper, its BST, defensive stats, and highest attacking stat are all higher than Tinkaton's, and it even has an ability that effectively boosts its defense even further. However, unlike Tinkaton, Wo-Chien is held back by an extremely vulnerable Dark/Grass typing (including a 4× weakness to U-turn) and a lackluster movepool that can struggle to apply enough offensive pressure to prevent opponents from setting up. As a result, it has sadly dropped down to NeverUsed over time.
So overall, when evaluating whether a Pokémon has a good or bad stat, you should consider the bigger picture instead of just looking at the number.