For simple things I use Apples suite. For complex things I use solutions like laTeX and custom scripts.
Same here. At home I do simple documents in Pages, and I sometimes use Numbers, but I don‘t often have use for a spreadsheet here.
For more complex documents I use LaTeX. What I really missed in Pages once, was the possibility to mix portrait and landscape orientation in the same document. Pages can do both, but not mixed in one document (at least I hadn‘t found a way to do it).
Used to hate Excel, but I had to use it for work a lot in the last eight years. I‘m still not an Excel lover, but having to handle thousands of data points for different communication protocols, I am glad that I can use formulas to automate a lot of work that would otherwise be very tedious or error prone.
The interesting thing is that my boss tried to add decoding of the OpenOffice table format to our products first, but it was too resource consuming for our embedded products, therefore he opted for Excel instead.
But I still hate Word with a passion, because it often does things that make no sense: I think you wanted to do this… No I didn‘t! I would have told you to that explicitly, if I wanted to do that.
The worst case happened probably over 20 years ago:
I had the audacity to set a single word in a table bold, because I wanted to emphasize it.
The process in Word must have been like this: That text style is the same that I use for captions, therefore this must be a cation as well, and I put captions in the table of contents… done!
Anyway, that single word that was part of a table ended up in the table of contents and I found no way to tell Word not to do that. The only possible solution was to undo and use a different way to emphasize that word.
Also, there is this old joke, that Microsoft wanted to name the product Text, but then noticed that it is not suitable for longer documents, which is why they renamed it to Word.
I‘m pretty sure they named it Word, because of the competitor Word Perfect, but there is some truth to it that it isn‘t very capable with more complex documents.
When my main computer was still an Acorn RiscPC with RISC OS, I had a product called TexWriter, because it was a WYSIWYG program that could also output TeX code. But it was also capable of reading and saving the Word document format at that time. Some people were known to repair Word documents with it that Word itself screwed up so much that it couldn‘t open them anymore.