I agree with you. SQL IDE Pro is a great tool, and I'm really upset that Quest decided to knock it off in favor of their crappy replacement TOAD. It sucked for Oracle and it sucks for MS.
I've tried ApexSQL several times, but it's a HUGE memory hog. Just running a simple query that returns maybe 100 rows ends up using almost 500mb of memory between real and virtual. I think the grid idea is interesting that you can group things, but I would rather they use the grid in SQL IDE Pro - that thing is FAST!
Other tools I use:
Litespeed SQL Backup (go for the pro and get encryption)
AdeptSQLDiff - great, fast tool for finding out what's different between production and QA/DEV.
Diagnostic Manager (Idera) can be great for tracking down issues with the database, nice monitoring tool, but a little pricey.
My company purchased ER/Studio which works well, but CaseStudio2 (casestudio.com) works just as well for most projects and costs about 1 billionth the amount.
Multi-Edit - I've been using this since the DOS days and it's a great editor.
For quick (I can bring it with me), I like PSPad or Metapad - both are great replacements for Notepad.