Lisps are very good for producing DSLs; when you have macros you have very powerful control over the syntax and can therefore produce your own language within the language.
The Common Lisp LOOP macro is a great example of power of macros; though in that case it is debatable whether it was used for good or bad.