HeidiSQL is one of the most prominent real world applications in Delphi I know of. It's been hard to find many others. Most likely they exist at many companies in private.
A couple more well known titles are:
- BeyondCompare
- InnoSetup
- Nero Burning ROM
- Macromedia Dreamweaver!