How Tacky is too Tacky?

So... I have read many a book in my time, mainly those of the fictional or fantasy genre. Things like LotR for example, that are well put together and have a relate-able feel to them in most aspects seem to be just fine. I never found the elves or walking talking trees, too 'tacky'. At first growing up as a non gamer/tv watcher/writer of any sort, a movie like this or harry potter as well as their book counterparts, seemed suuuuuuuper nerdy/tacky. Even star wars was hard to get used to, but after a while, and getting more and more into reading, and watching tv series or popular movies, I became more and more fascinated with this particular genre. I got more and more into lore rich games, and enjoyed reading books that I found out existed through their television versions.

Now then... in terms of attraction or 'what killed it for you'... where is the line drawn? For me its the stereotypical king needs a dragon slain, young farmer or what ever rises up to the challenge and does it. Said farmer is now a knight, and takes on other hero/villain like quests... To me this is just... and I dont mean to offend, but its too much tackiness.

I mainly would like to read about y'all and your thoughts on this subject, so that I can get an idea of what to avoid and what to strive for in terms of content delivery to a reader. Do keep in mind this is mainly about fictional or fantasy/adventure genres. Examples would help shine the light brighter, but ya... what makes you not want to continue, or what point does it have to reach for you to stop desiring to read said book?

How Tacky is too Tacky?