I've finished Yellow, Gold, and Soul Silver. I have some experience with the series but I'm not a total veteran. For example, I tend to quit the game after the Elite Four. But for some reason, this new game is exciting me. Maybe it's a combination of the new graphics and the fact that 3DS will surely make online battling even easier than before. When I sit and think about it a little, though, I don't know WHY I've got myself hyped beyond that. I guess it's the expectation that this will be the game where I finally decide to try a bit of competitive battling.
You should be hyped. It looks like the most radically change pokemon to date. The gameplay looks great, the graphics look very nice, AND it's in 3d! If you have not played since soul Silver, i'd say go for it. You have over 200+ pokemon to look forward to, not to mention gigantic gameplay changes has happened since then. The metagame is in for a giant shift too, so now is the best time to look into it competively. That is, if your into all of that.