How large do you mean when you say you want to print for your own frames? This will have a great impact on what you get.
I've only printed up to 8x10 from my point and shoot with good results. Above that (I printed some pics about 12x15 or so last Christmas) it gets sketchy. Cropped images are definitely no good. The only thing larger than this that I've printed was shot professionally.
How do you plan to print them? At home or use a lab?
lab
How much time do you like spending infront of your computer?
I don't mind spending time processing images for print. I have access to photoshop and some experience using it.
How camera literate are you?
Not very. I'm a research scientist, and I work daily with micrscopes, so I have a good understanding of optics (as in high mag objectives), CCDs, etc; but I have no experience with cameras or their lenses.
How much time are you willing to invest?
Like any hobby, I'm not opposed to putting in time to learn. The trouble is finding the time between the job, the family, and the numerous projects in the shop and around the house.
Most people want the same things: small, light, easy to carry, reasonable cost, and able to blow up the photo to fit half of the planet. Oh, and they want it to last until they die.
Just like wooodworking tools, it don't work that t'way.
I am quite aware of the limitations of each type of camera, and the trade-offs that come with each.
The more bells and whistles you add the less the camera will last but the more they'll charge you for it.
I hate to be mean but if you don't have a video camera around to shoot video it's perhaps dubious you're more likely to have a photo camera around to shoot video. Sometimes the facts need to be faced. And the amount of video the vast majority of DSLR's can shoot is very time limited. Yup, they're handy when they're at hand but they're not video cameras.
I'm not looking to shoot hour long high quality videos. For birthday parties and such, I'll get out the video camera. My queation was whether these SLRs can shoot acceptable short clips, or whether this feature is just a throwaway. My reason for this is that my videocamera is packed away in a bag in a closet, while I keep the photo camera sitting on a shelf near the TV. When the little guy does something cute (like the other night, walking around with a diaper on his head), I'd like to be able to grab the camera and catch a quick video.
I own more cameras than I care to admit and have been teaching photography for years, and in my humble opinion I would recommend one of the better point and shoot cameras, and here's why: the quality is good and one of their best qualities is they're small. You've already found out that MP count means nothing. I'll put my old 4.1 MP D2H against most 12 MP cameras for prints up to 8x10, which most people rarely ever print larger than. Like saw blades, pixels come in different qualities.
To cut this short, before you invest in a whopper of a camera take a look at something like the Canon G11 (I'm a Nikon guy and even I own one). The results are very good, and although it pains me to say it, that's the camera I pick up more often than the others.
There's a forum around with info about a guy who has won photo contests shooting with a disposable camera with no settings. The reason is wins is he shoots to the camera's strengths and he knows what he's doing - in part to prove it's not the camera it's the photographer. If you really want to take better photos consider taking a course, and you can even do that before getting the camera.
Best of luck traversing the camera jungle
If I can help you in any way please feel free to let me know.