Chekov's Spell -- This spell has a two-fold effect. The first is to make the target item almost-unnoticeable to anyone not specifically looking for it. The second is that someone who has seen the item will remember it when they encounter a situation that would be perfectly solved by use of said item.
For a futuristic grim gory setting. Probably powered by some kind of dilithium battery or something similarly awesome. Anyways, basicly a big drill sticking up from a hilt that you primarily use for skewering enemies painfully and drilling through armor.