From http://www.irfanview.com/
It's a fully functional image editing software. Your additional requirement for frame effects is a little more difficult.
It might be that Adobe's Photoshop would do that, (I don't know for sure), but that is not free.
However, you could cheat! Make your own frames using something like Windows Paint, (aka Paint or MSPaint), which is installed on all Windows Systems, or scour the internet for interesting frames, save the images to your hard drive, then edit the frames in Paint or Irfanview. You may need to check copyright issues, but there will be many free images available.
It will take time, but I've done it myself and it is very satisfying.
Mark
Hello, I'm looking for a free photo program to download that comes with editing tools like cropping and stretching, but also comes with frames like picture frames a person would use to hang a photo on a wall. Gold, plain, wacky, ornate, whatever. I sell antique, rare books, and everyday books, so I'd love to find a program that comes with frames, so that when a person goes to a book store that's on line, and 35 people are selling the same 3 little kitten golden book, mine will stand out or be noticed. Thanks in advance Ann

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic