My list of desired feature and improvements looks something like this:
Instance/cluster aware SSIS.
Scheduled Servicepack release schedule, like once per year (yes, I would consider this a feature!:-))
Many improvements to Management Studio, including, but not limited to
- GUI interface to some of the newer engine features, that require T-SQL to interact with.
- better stability, less freezes when an action in one window takes a long time complete.
- redesign of many "sub windows", so there is adequate space to the information they hold and they are resizeable.
Other areas, where improvements are overdue:
Cleanup in old system SPs and views, correct spelling mistakes.