I've been running Fedora 17 KDE for the last 4 yours and I am very happy with it.
Some minor inconveniences, but nothing that I couldn't change to my preferences so far. Unity seems actually a good choice for people who want a simple out of the box OS that just runs without any additional work. But that was actually the main reason I wanted to get away from Windows, so KDE seems to be the thing just for me.
The move to trash confirmation is actually a bit scary, though. With that large warning symbol and a full list of the items selected for deletion. But yeah, that's basically what I had asked for.
A last question, though: I can check "Do not ask again". Does that apply to the entire system or only to a given folder, set of folders, or something like that?