i was the same way with skyrim, probably ran the intro scenario like 11 times and every time just got bored and quit in the first hour. eventually i just said fuck it and told myself to finish, after about 4 hours i started to enjoy it and did finally finish the game over a period of a few weeks, a lot of the mods helped make it more interesting/fun and this was after all the DLCs were out. Some of the mods are just nuts, like the extended stories stuff.
still, overall i'd say my enjoyment of skyrim is like 6/10, its definitely a great game but i just don't get too immersed into that world, whereas something like assassins creed or mass effect or Saints Row or GTA is full out 10/10 chubby. probably a reason why i completely despised TESO from the first minute.
tl;dr version - get legendary edition (all DLCs), go to the nexus mod site and install the top 10 or 15 mods that look interesting, and force yourself to play for a few days. you get into it.