For example, can an artificer create a wand of personal weapon augmentation[?]
Yes
[I]f so, must the artificer make a Use Magic Device skill check to activate that wand?
No.
While an artificer must use a Use Magic Device check to operate even a Wand of Light that he creates (confusingly), for the purpose of creating magic items the distinction between infusions and spells only seems to matter when an infusion which shares a name for a spell is placed into a spell completion or spell trigger item.
An artificer cannot automatically use a spell trigger or spell completion item if the equivalent spell appears on his infusion list. [ECS p.31]
That is, if an infusion and a spell share a name and function (like the example of light), then the artificer cannot automatically use a spell trigger or spell completion item with that spell or infusion. (Literally speaking, it seems the game system does a "check" to see if infusion X is "equivalent" to any spell in the game not on the artificer's infusion list. If the check finds an equivalent, then the artificer must use Use Magic Device to activate the spell trigger or spell completion item.)
What does this means for an artificer that wants to create and activate magic items directly incorporating infusions?
Ignoring for a moment wands and scrolls, a creative artificer could create a Tab of Personal Weapon Augmentation, standard action to activate, usable 3 times per day, and distribute those throughout his party. Whilst an artificer is held to certain standards regarding the usage of spell completion and spell trigger items, no one in his party is, and none of the limitations regarding infusions limit their eligibility as possible magic items. Indeed, in lieu of a specific rule regarding magic items, infusions "function just like spells and follow all the rules for spells[.]" Rings of Spell Storing or Imbue Familiar with Spell Like Ability (presuming a familiar or item familiar) are certainly valid targets for various infusions, as well.
Or, re-stated: