Does GumLeaf Gutter Guard go over the first tile and look unattractive?

No, GumLeaf gutter protection has a step system whereby it is attached to the top of the gutter lip, goes to the first tile, takes a step down and rests on the fascia board under the first tile.