Thats the plan I signed up for, so lets see if I can answer from what I've learned here....
$142.20/year is what I paid for 1 year as well, should be the 1yr cost.
You can stream audio/video, although if it causes a lot of stress on the server, you will probably be asked to get a VDS (virtual dedicated server)
Flash/Shockwave, yep.. no problem, the plan does not limit the "type" of files you have on the server, only the content of them (no adult/illegal etc)
Cold Fusion... Pretty sure, no... I think there was a thread about this the other day, and it was determined it does not support it.
SSL, I belive its $10 for a dedicated IP so you can do it, I also belive they offer shared, someone from hostony will need to answer this one... You have to pay for your certificate either way.
The Database is part of your storage space, as well as your email storage is part of that as well.
By Schemas if you mean tables/databases etc, No Limit (according to plan)
You have full POP3 and SMTP access to the server, so you can use any mail client you wish.
The mailbox size is limited by your account space, you can set a "quota" on any of the accounts if you wish, or none...
Free scripts abundant.. lets see if I can produce a list here (this is from my linux hosting)
Fantastico Scripts:
CODE
Blogs
b2
b2evolution
Nucleus
pMachine Free
WordPress
Content Management
Drupal
Geeklog
Mambo Open Source
PHP-Nuke
phpWCMS
phpWebSite
Post-Nuke
Siteframe
Xoops
Customer Support
Crafty Syntax Live Help
Help Center Live
osTicket
PHP Support Tickets
Support Logic Helpdesk
Support Services Manager
Discussion Boards
Invision Board
phpBB2
YaBBSE
E-Commerce
CubeCart
OS Commerce
F.A.Q.
FAQMasterFlex
Image Galleries
4Images Gallery
Coppermine Photo Gallery
Mailing Lists
PHPlist
Polls and Surveys
Advanced Poll
phpESP
PHPSurveyor
Project Management
dotProject
PHProjekt
Wiki
PhpWiki
TikiWiki
Other Scripts
Moodle
Noahs Classifieds
Open-Realty
phpAdsNew
PHPauction
phpCOIN
phpFormGenerator
phpLinks
WebCalendar
And Scripts from just Cpanel:
CODE
phpBB
PhpBB is a web bulletin board system.
AdvancedGuestBook
Advanced Guestbook is a PHP-based guestbook script.
InvisionBoard
InvisionBoard is a web bulletin board system.
PHP-Nuke
PHP-Nuke is an advanced content management system.
osCommerce
osCommerce is an easy to use and configure shopping cart system.
Hope that helps you...
Jason