Have you looked at the Generico plugin? Its actually a filter, but it adds custom html / css / js to wherever it acts upon. So you can use in a regular page activity, to embed youtube, or add lightboxes etc. It can do basic database lookups. If you look at the Generico showcase thread, you can see some of what other people have made.
Here are some links:
Generico Showcase Forum