We have used Ubuntu only with OOo (now LibreOffice) on all our computers since 2008, and on one computer since 2006.
And we have used LibreOffice since it was called StarOffice, more than ten years ago. In all these years we have only come across ONE document (Excel) that was not readable in the free office program. (An early version of OpenOffice run on Windows XP.)
Our website (http://valutronic.se) is 100% made with LibreOffice´s Writer/Web (WYSIWYG editor).
Adding hardware like printers is a breeze -- Typically, while connected to the Internet, just connect the printer, turn it on and wait a few seconds. A sign pops up telling you the printer is connected and working.
Software installation is best done via a Software center. If the program has dependencies (extra drivers needed) these are installed automatically. A child can do it, you don´t need any previous experience. No need for opening a terminal window any more.
The new desktop might look strange at first (I first hated it because it was so "different from what you are used to" -- a sign of starting dementia???)...
but when you get used to it and find out how intelligent it works, you will probably love it. I do now.
We still use Windows XP for an old TV card and our GPS map downloading software at home, but for all our business needs we use 100% Ubuntu.
So, my advice is: Install it on one computer, use it for a week and find out yourself.
In LibreOffice, you can save your work both natively in OpenDocument formats, or if you want to send them to others who use MS Office, in MS Office formats.
Install "Ubuntu restricted extras" and VLC media player and your Internet and multimedia experience will also be just fine. If you do advanced image retouching, try GIMP (some learning curve, however) and if you need to automatic colour correction for bad photos, try Pinta. Just install whatever you fancy from the Software center and try out the software. Almost all is free, so there is no reason not to.
Best regards
Stefan Berge, Valutronic, Sweden