+1 for the CycleOps Fluid 2. Plus, you can get one off ebay (new, with a full warranty) for a little over $200.

http://www.thesufferfest.com/ has awesome real riding videos that put you in a crit or road race and then give you awesome instructions about accelerating, heart rate zone, etc.

Oh, and its free! And there are great links to other spinning resources (like audio podcasts of fast trance music etc)