All you need to know about command line is, how to open a terminal, and where to find online the commands you want to run. I so rarely run any command line stuff. I don't need to memorize any of it. No more than I need to in Windows. Which is a great strength in Linux. If I want to be a user that does open Bash every time I boot the computer, I can. Or I can use one of several other gui tools to do that for me.
The whole MS Office ordeal. It is an ordeal. It is not even compatible with itself over several generations. Currently I use LibreOffice Suite. If I need to create a PDF, I start in LibreOffice and then open the document in AbiWord, then save it as a PDF file. I have a decade of documents for the public office I serve as treasurer, all created with OpenOffice or LibreOffice.
There should be no reason for Linux to not make use of any Microtek scanner. But you may have to use the command line to get it setup. Then it should work in SANE. Google everything you can about it and read up on it. Then give it a try. Unless something in the firmware of that scanner says "Microsoft only", it can be made to work. What model is it?
Yeah, some of the software packages do seem to be a bit behind. It just take a focus on peoples interest and packages can improve. Or multiple choices suddenly appear. I don't particularly like Gramps either.
From the very first time I plugged in my Maverick Audio tube DAC Linux knew exactly what it was and made use of it no problem. Because people before me were interested in great sound and smoothed the path for me.