Minecraft can be extremely addictive. I know from personal experience. To give you an idea, I'm a freelancer and for a large percentage of last year I was playing more hours of MC a week than I was billing clients.
You sound like you may be similar to me with games so let me lay it out for you.
When you first start playing you know nothing. There's so much to do and learn. You'll be scared of nighttime and dark caves. You won't know how to craft anything. You'll probably get killed a lot and get lost. It will suck you in for the first 30-60 hours while you learn how to play single player.
At that point one of two things happen. Either you really like building structures and you keep playing a lot or you get bored. I got bored.
Then I realized I was only experiencing a small fraction of the game. The modding community is HUGE, larger than any other game I've played. There are hundreds of mods available that expand and modify gameplay making it far more interesting than "vanilla" MC. Each mod can add 5-50+ hours of interesting gameplay.
This isn't even accounting for multiplayer, which can be much different. PvP servers with clans, mod servers with large towns, creative servers with builds that take months to complete.
I'm not saying you shouldn't play. Minecraft is a great game. Just be aware of where it can lead if you don't plan your time well. I've since cut way back and don't play games as much.
One way you can get a good feel for MC is to watch some of the popular YouTubers. I primarily watch the Yogscast but there are plenty of other good ones.
This makes the pocket and xbox edition experience quite a bit different from the PC/servers version.
My experience was I made a lair basically tunneling out an entire 100x50 ish island, built a tower going up until I was bored and a spiral staircase from top down to bedrock, then dug what amounts to a giant multi-lobed endless loop subway just above sea level around the map (probably about 4 minutes, yes that is indeed a lot of mined/smelted iron, and gold/redstone to boost my cart up to speed) diverted into optimized partially-automated chicken production, then got kinda bored. I think I got about a hundred hours of fun out of it, which, for what it costs, is an excellent rate of return.
It reminds me of an old saying about "second life" from about a decade ago, where if you can't be entranced by it for at least a dozen hours, there's probably something wrong with you, but much after a hundred hours or so, its kind of boring.
A third comparison of about equal depth and entertainment was playing Eve:Online also about a decade or so ago without joining any social groups (which was impossible because I was scavenging random hours here and there, and clans wanted dedicated scheduled mining/raiding nights and such)
All three share the characteristic that its hard to go beyond a hundred or so hours without the community, although if the community drags you in, then you're stuck in there forever.
There's probably a startup lesson in here that if you want more than 100 hours of engagement, its going to come from the community, not the programmers / artists / suits.
I've gotten to the point where I'm not sucked in and addicted to MC anymore, but since it was the building part that I got stuck on, never modding or multi-player, I still get plenty of enjoyment when I periodically think of something new to build.
(E.g. I built a residence, garden, etc. in a cloud then decided I could expand that to a several-cloud city. Then decided I could build a tower with railroad in an attempt to bring cows and pigs up there. The next project might be an underwater city, or play around with the new horse stuff they added.)
New content is added occasionally. I'm not entirely sure why, since they don't have continuous subscription revenue like WOW does. I actually find it kind of annoying since then I need to explore another huge swath of territory to get new chunks to generate with the new stuff in it. Or worse, if the new stuff breaks the timing on some of my red stone circuitry or the effectiveness of my experience generator.
Similar to the game he canned, check out Red Power 2 for MC, it's actually got an in-game computer you can program it in Forth, save programs on in-game floppies, and build a giant IO bus to control various things in the game world.
You sound like you may be similar to me with games so let me lay it out for you.
When you first start playing you know nothing. There's so much to do and learn. You'll be scared of nighttime and dark caves. You won't know how to craft anything. You'll probably get killed a lot and get lost. It will suck you in for the first 30-60 hours while you learn how to play single player.
At that point one of two things happen. Either you really like building structures and you keep playing a lot or you get bored. I got bored.
Then I realized I was only experiencing a small fraction of the game. The modding community is HUGE, larger than any other game I've played. There are hundreds of mods available that expand and modify gameplay making it far more interesting than "vanilla" MC. Each mod can add 5-50+ hours of interesting gameplay.
This isn't even accounting for multiplayer, which can be much different. PvP servers with clans, mod servers with large towns, creative servers with builds that take months to complete.
I'm not saying you shouldn't play. Minecraft is a great game. Just be aware of where it can lead if you don't plan your time well. I've since cut way back and don't play games as much.
One way you can get a good feel for MC is to watch some of the popular YouTubers. I primarily watch the Yogscast but there are plenty of other good ones.