I agree 100% with Bowerandy. I work for a largish publishing company but spend most of my time developing these days and Lion has been a nightmare for all the reasons stated. The file sharing is terrible - the lack of AFP access to Windows servers is beyond a nuisance and connecting via SMB is woeful. Even to our XServes the performance is poor compared to SL.
I too have been having problems with Preview - it hangs every time I try to open a freshly taken screen shot.
Performance in general is terrible - constant pauses and freezes - just seems to sit and wait several seconds before deciding whether it wants to do what you've asked. It may well be the versioning as opening and closing docs seems to be the worst affected.
The auto save drives me insane, I create a quick text document to hold some text, close it and then it pops up again next time I open the app. I open a Keynote doc, copy some text, then get the locked warning. I tell it to unlock and then when I close it - without making any changes other than the copy - and it resaves it (A pain when the doc contains video and is several GB is size).
Rosetta doesn't really worry me, I only have a single PPC app that I need and I have 50 other machines here I can use for that.
I'm also having severe issues with web sites crashing - in particular our own site where we get people to submit text and photos via a simple HTML/PHP form. Hard crashes both Safari and Firefox running on Lion but both work fine with SL. IE and Firefox on Windows is fine as well.
Printing has also been a problem for us - several printer drivers were broken with security updates.
I deliberately waited to install Lion as there was no need for us to rush in. The thing that tipped us was iBook Author - we wanted to look what it could do for us. Well the pain isn't worth it.
I ran Lion for 22 days and gave it as good a chance as possible. The downgrade to SL has been the most painful experience I've ever had with Apple products - despite having a TM back and a SparseDisk Image of my SL machine.
In the past there's been OSs I've not particularly liked, but this is the first time I can genuinely say I've hated an OS. This release has truly angered me and I'm usually a 'go with the flow' type guy.
We have 75 employees and many are due for new machines this year. I can categorically say - as I'm the IT manager who makes the decision - that we won't be purchasing any new machines unless we can get an assurance they will work with SL, or unless Lion makes some sort of Lazarus type recovery over the next few months.
As for the roll back - it took nearly two days to get a proper running system back up. I ended up doing a clean SL install on a Firewire drive after doing clones of my running Lion machine. As others have said, your SL Time machine backup is worthless once you've 'upgraded' to Lion. That alone angers me - that there's no warning when moving to Lion that your precious TM backups will be rendered useless.
Anyway, long story short, Clean SL install with same username as previous machine, clone existing Lion drive (just in case everything goes pear shaped), install required software onto clean SL, wipe Lion HD, Clone back, restart. Reconnect TM which should now show your SL backups, decide what you need and copy it all back. I also had to go through migrating 22 days worth of mail from my Lion machine to my new SL install. Painfully slow with large drives...
One word for Lion - abyssmal!