Personally, I wouldn't do handscraped floors in the kitchen. Too much dirt/grease flying around if you actually cook, some of which will wind up in the scrapes and never be clean.

Solid vs. engineered is your choice. Solid is a long-term investment, and will last as long as you own the home if properly cared for, although you may need to refinish them. Engineered may save you a few bucks on the front end, but you will probably lose at least one refinish (but who cares if you're not going to be in the house 20+ years).

Satin vs semi-gloss is your preference too. Since your prefer slightly glossy floors, you will never like the matte. If you take care of your floors, either satin or semi-gloss is fine. If you have an extremely high traffic area, you can always use a runner to protect that area.

What is the substrate underneath the tiles? Concrete slab vs. wood joists/plywood subfloor?

The type of substrate may be the determining factor as to what will work vs. what won't.

Agree on avoiding the hand scraped look. We have solid white oak with a water based matte finish and it has been great, easy to maintain with pets and kids. We had satin previously and it was fine too.