Laconic / Awesome, but Impractical

Something that's really useful/powerful, but has so many drawbacks that it's rarely used.
Visit the impractically awesome version HERE

http://tvtropes.org/pmwiki/pmwiki.php/Laconic/AwesomebutImpractical