Overal the issue is support over the tiers
The base 2024 ranger scales like this
Tier 1: Free Uses of Hunter's Mark, Deft Explorer
Tier 2: Extra Attack, 2nd level spells
Tier 3: Tireless, Expertise 3rd level spells
Tier 4: Precise Hunter, 5th level levels
The weak spot is the lack of strong 3rd and 5th level spells. Easily fixed. There are 4 editions of Ranger to convert spells from. There are tons of comics,/books video games, and cartoons/anime to be inspired from.
For a nonspellcasting Ranger, it's much worse.
Tier 1: Free Uses of Hunter's Mark, Deft Explorer
Tier 2: Extra Attack,
2nd level spells
Tier 3: Tireless, Expertise,
3rd level spells
Tier 4: Precise Hunter,
5th level levels
There are few Tier 3&4 features that most homebrew designers suggest that aren't some combination
- Straight up stealing from the Fighter or Rogue
- Mechanically boring and not exciting to onlookers
- Blatantly OP and would never be oked by a good DM
So when people say Ranger drops off in Tier 3, the easy fix is to convert Blade Thrist, Hunter Eye, or Arrowmind from old editions or take Exploding Arrow, Animal/Fey/Plant summoning, or Natural Animal PEDs from other media. The hard part is coming out with new interesting nonmagical stuff.