A few points:

An early beta of Yukon (first beta iirc) did indeed have intellisense.  It was awesome.

SQL Prompt was resource intensive so even though it was very cool, I quit using it.  No problem, I can live without it, but I liked the idea.

And as to the complaint of some people that intellisense is intrusive, unnecessary, whatever:  turn it off if you don't like it.  I don't know of any development app where you can't turn it off if you want to, but for me, it's useful to be able to browse through all the methods, function, properties, etc, and darned handy to save typing.