@mantisspider
Your question has started an interesting thread, here's my list:
Wordprocessing: Final Writer 5 - Powerful and easy to use for basic WP although it lacks some fancier features like tables.
DeskTop Publishing App: PageStream 4.1 - Fantastic app, powerful yet pretty simple to use. We use PageStream to layout Total Amiga magazine so I spend a lot of time using it

Image Editing apps: I use ImageFX more than any other, it's very powerful, with great layers features. I find IFX best for image processing and composition rather than "painting". It takes a while to learn but is well worth the effort. I also use Photogenics 5 and Personal Paint on a regular basis.
Spreadsheet: Final Calc
Database: Fiasco - It's a neat little shareware DB.
Scanning software: fxScan
CDwriting: MakeCD
EMail app: Thor - I like Thor because it combines E-mail and newsgroups in one program.
WebBrowser: IBrowse 2.3
Video Player: FroggerNG