Can Magento by default do this?
This is a static page showing a project (photo, text, download pdf instructions) and below these photos there are the products used in this project and you can add them to the cart from this page.
Example url: http://www.fusionbeads.com/Summer-Swirl-Earrings
Is there any live Magento web site like this ?
For this you can use the concept of the Magneto Group Products and customize the layout according to your requriement.