The artificer tends to be support oriented, so if you are looking for high DPR it isn't a particularly good choice.
Having said that, Artificer works well if you want to build an intelligence-focused rogue (Arcane Trickster). A one level dip gives you medium armour, shield, con saves, an extra caster level (artificer levels round up) and INT Magic Stone. Which, when loaded into a sling, can be used to sneak attack. Three levels of Artificer (Battle Smith) gives you INT based attacks on all your weapons, and a pet which, although not optimised, can help make sure you qualify for sneak attacks. Oh, and +2 caster levels. Either artificer or rogue works as your main class after level 6.
It's only useful with a wizard multiclass if you want to play a gish. For example, Battlesmith/Bladesinger. Exploring Eberron has an artificer subclass that is better than battlesmith for this build.