Ignorant Teacher, I have two suggestions for you if other people's enthusiasm just won't rub off. (It happens. Nobody can enjoy something for you, and reasonable people can have different responses to the same things, whether it's books, movies, or games.)
First, even if Civ5 leaves you cold right now, you haven't wasted your money. You still own the game, and they'll be patching and upgrading it. There will also be lots of user-made mods. This isn't an excuse for Firaxis releasing an unfinished product - if you paid for a cake and received a box of cake mix, you've been cheated! - but hopefully it will make you feel a little better about your investment.
Second, try out some mods! There are only a few so far, but I think people have already started tweaking the economy and production rates to give you more to do in the early game. Sometimes little things like that can make a big difference to the feel of the game.
Personally, the thing that I like most about Civ5 is that it's
different. Civ4 is wonderful, but it's also very familiar to me by now, and the new game has tons of new things to learn.
I really prefer social policies to civics. Your first choices in Civ4 were pretty straightforward - convert to the first religion that infects your cities, switch to Slavery right away or wait for Monarchy/Organized Religion - and they didn't take place for quite some time. In Civ5, you get your first policy pretty quickly, possibly within a turn or two if you explore the right ruin, and there are three completely different choices. Do you want to improve your capitol, expand quickly, or kick barbarian butt? No matter what you choose, by the next time you get a policy (which can also be quite soon), you now have four or five choices. Do you want to explore your first policy more, or unlock one of the others? You can start customizing your civilization very quickly. They're better at showing your culture's strengths (building, expansion, war) than they are at really showing flavor (monarchy vs. republic), and there's a pretty narrow range of choices to make if you're going for a cultural victory, but overall they give exponentially more choices than the civics system. And I loved the civics system!
I also like the way city-states complicate diplomacy right away. They definitely need a little balancing (Maritime CSes are abusively powerful), but overall they give civs another reason to compete, either quietly or with open war. I laughed like a lunatic the first time I bribed a city-state into switching to my side in the middle of a war, completely sabotaging Bismarck's advance. I laughed even harder the first time al-Rashid did the same thing to me!
Besides, I'm not sure I like the empire-wide implementations of this game. Some people said that they think Civ 5 makes you specialize your cities more, the way culture and happiness are there, I feel cities lost their "individuality." (sorry, second language)
With the long build times and high maintenance costs, I think it's even more important to specialize cities in Civ5. You literally cannot afford to build everything in all cities. You have to decide if a city will be for gold, science, production, culture, or
possibly a couple of them. On the plus side, cultural cities matter even if you're not going for a cultural victory. More policies let you specialize your civ further, so you'll always benefit from another opera house, even if it's in a city that doesn't need to expand its borders. There are also a lot of buildings with very specific requirements, so location matters a great deal. For example, you can only build observatories in buildings that are next to mountains, and you need incense or wine in the city radius to build a monastery (for extra culture). Once I started noticing these details, cities gained a lot of personality.
[Tech trading] was easily one of the most exploited things in previous civs. I'm still not sure about the new system though.
I have mixed feelings, too. Tech trading was a flawed system, but research agreements are really bland by comparison. It's also one less thing to do in diplomacy, which is one of the reasons why diplomacy feels so much less engaging.
I think it is still too early to have a final say regarding diplomacy. Let's give the code-divers some time and they might show us that the AIs behave as mechanically as in Civ4. Or that it diplomacy is truly innovative. Too soon to have an opinion.
I think what we'll find is that the AI is attempting to do complicated things but is failing quite badly at them. I have observed it getting upset because I was allying with its favorite city-states, or because I beat it to a World Wonder too many times. Civ5's AI is definitely responding to more events than Civ4's does. It needs to give better feedback, though, and needs a
lot of fine tuning.
Anyway, thanks for creating a positive thread to discuss the pros of Civ5. It's not a perfect game - YET - but hopefully it will become one that you enjoy, or at least enjoy discussing.