I HATED Tiger's Show All Spotlight window. It showed way to many results and I found the Sorting options to be garbage.
You aren't alone. I think integrating it into Finder WHILE ADDING* functionality was the right thing to do. To me, it's a hundred times more useful.
*Advanced Boolean searches are now available unlike in Tiger.
yes, boolean operators are most welcome. but for me the organization of the results window still offsets those gains--it just makes it so much harder than it was in tiger to scan through the results. i most frequently use spotlight to search for PDFs, and so i loved having them grouped together.