yes, sad but i did the same, tried lion on my macbook pro which completely mangled everything in my system and made my bootcamp/pc partition unuseable. So i completely wiped the mac partition and reloaded snowleopard which i love. I think some of the problem may have been the fact it could not find a backup area, so i now have that set up and am going to try again, but only because i feel i have to! Like the last entry, i expect we will be forced off by some means or other. I still have sl on my imac for all my clubs/groups (4) membership management etc. I am loathe to lose it.
i feel all the 'improvements' in l and ml are purely to cater for all the pc users and others who are now in the mac envelope via the ipads and phones as many of the actions seem to cater more for the people who live their lives on these community systems, rather than those who use macs for more practical reasons. It is almost as if apple is dumbing down for the masses which is fine for them, but no so good for the macusers who've been with macs for yonks.
So i would say to bruleke if you are happy with snow leopard keep it as long as you feel you can. Ultimately it will be really old hat and in a moment of gung ho! You will decide to buy a new machine or go for it. Beware, as you get older (i don't know your age, but i am getting on now) and radical changes are not so easy to take on board. Perhaps that is the problem