Thieves' Tools still exist.
Thieves’ Tools(25 GP)
Ability: Dexterity
Utilize: Pick a lock (DC 15), or disarm a trap (DC 15)
Sleight of Hand as an applicable skill proficiency doesn't change that. It's still a tool proficiency. Rogues and Artificers both gain that tool proficiency with the class.
What happens is if they both also take Sleight of Hand then they gain advantage using Thieves' Tools.
Rogues can take Expertise in Sleight of Hand at 1st or 6th, can no longer take Expertise in tools including Thieves' Tools, and can avoid Expertise in favor of other skills relying on DEX bonus, proficiency, and advantage. Or they can keep it simpler without taking Sleight of Hand and all relying on Thieves' Tools proficiency and DEX bonus.
Artificers automatically have Expertise in Thieves' Tools at 6th level. At 1st level they can take proficiency in Sleight of Hand as well for advantage. At 7th level when the Rogue is also adding Reliable Talent the Artificer is adding Flash of Genius.
I wouldn't call 6th and 7th levels rear-loaded when those are strong skill levels for Rogues too and advantage is available early for either.
Same with Infusions. Cap of Water Breathing or Goggles of Night help. Boots or Cloak of Elvenkind later.