here are mine:
(well known, so i think no comments needed)
AtlasLoot
Auctioneer
Cartographer
DamageMeters
Gatherer
ItemRack
OmenThreatMeter - i dont use it much cuz really few ppl have this
Quartz
QuestHelper
TitanPanel
X-Perl
and others:
AckisRecipeList - shows what recipes u still dont have and shows where to get them (some of recipes :\ )
AutoProfitX - 1 btn sell all grey items
Bagnon - single bag and bank window. Saves lots of space
Bongos3 - Alternate action bars
EvesDrop - User friendly combat log
ElkBuffBars - shows buffs and debuffs in bars. may be splited to different collumns (i made debuffs to left and buffs to right side)
Enchantrix - I think this remembers disenchanting results, but not sure...
EnhTooltip - enchanted tooltip
GroupCalendar - calendar which can synch data with guild members, keep ur notes and so on
InFlight - Shows remaining flight time between FPs
Informant - another enchanted tooltip... welll i think so...
LoatIt - Allows enable or disable addons without reloging
MinimapButtonFrame - get all buttons from minimap to single frame
MobInfo2 + MobHealth - makes DB after killing mobs with their HP, gold amount, droped items, items value....
RatingBuster - converts stats to real stats (example: 25 agility - 1% crit chance) in tooltip
ReverseEngineering - u want make Netherweave bag. U just Alt+Click on Bolt icon and mod auto makes bolts for single bag.... well not exactly this but...
SCT - scrollng combat text. Another extended combat log
SimpleRangeIndicator - shows range (0-5, 5-8,...)
SkillLevel - shows Skill lvl converted to player lvl ( 375 - 70 and so on)
SpamMeNot - blocks incoming smap and trades ( not tested much...carefull!)
TeksLoot - shows very tiny loot frames, so u can keep fighting when some noobs starts looting in middle of fight
TrinketMenu - Quick access to trinkets
later ill post screenshot with visible addons
EDIT:
ups forgot 1
OmniCC - shows CDs directly on buttons (auto changes font size and color of left time)