LogFAQs > #962865728

I would say:

Connery era: kind of fun/interesting in an old way. As mentioned above, they're mostly fun to watch these days to see the spoof references.
Moore era: some popcorn fun, but leaning towards dumb by today's standards.
Brosnan era: pretty good popcorn fun. Some dumb, but less so than with Moore.
Craig era: started with a good Casino Royale modernization, but largely lost the fun factor over time and became broody...and thus the same as everything else.

All in all: they're decent movies (some moreso than others) if you just want to pass a couple hours, but they're nothing amazing.