Anyone know if this website that claims to sell Ultra 2 as a download is a Scam or Legit?

Serious Magic was bought by Adobe a few years ago. Their product line was rolled into Creative Suite and no longer exits under its original product names.

anyone claiming to sell it is either selling several years old product, or is scamming you (and maybe both!).

On the front page, complete with spelling errors:

This software is provided 'as-is', without any express or implied warranty. In no event will this site be held liable for any damages arising from the use of this software. Seriousmagic.net is NOT related in any way to seriousmagic.com and/or Adobe. All Trademarks are reserved to respective and legitimate owners. Seriousmagic.net is just a trade site wich buy and sell used copies of this discontinued stand alone software, not anymore vailable on the market as individual application/products..

Well, at least they're not hiding the fact.

Ultra 2 was a fantastic product in its time and it's a crying shame (although no surprise) that Adobe dropped it. I think they also managed to make a hash of DV-Rack (now called On Location).