Everyone is entitled to their own opinion, but I disagree or maybe just don't understand your logic as cooling the attic space is one of the main objectives of spray foaming the roof line. It's also one of the biggest contributing factors to saving you energy and money. How is that a waste of time?
Can you expand on your thoughts?
You are bringing up two very different approaches to insulating a house that has nothing to do with venting an attic.
If you insulate your attic with any form of traditional fiberglass or some of the newer versions of blown in insulation, you are creating a barrier between the conditioned living space below the ceiling and the attic space above the ceiling. As more and more research goes into this, the standards have changed in how much to use to get the best results. The last I've heard, you want R 60 in your attic. This is the amount that will best keep the house cool or hot regardless of what is going on outside the house.
When insulating with this method, you have to have air flow to keep your lumber dry. First thing in the morning when the sun starts heating up the outside of the house, the cooler temps in the house will lead to condensation forming on the surface of everything in there if the humidity levels are high. This doesn't happen every day, but it does happen enough days out of the year to be a major concern. Venting has nothing to do with trying to lower the temperature of the attic space. Venting is all about drying off the moisture of the condensation.
Cooling off an attic is a sales gimmick that people have been using for decades to sell you something you don't need. First they convince you that you will save money on your energy bill if your attic isn't as hot because then it wont take as much energy to cool off your house. Then they convince you to install bigger fans because common sense has proven to you that if you sit in front of a fan, it will cool you off. This is flawed logic because at the very most you will only lower the temperature a few degrees, and that is only during the cooler times of the day. During the heat of the day, it's not going to do anything except move more air around. That's not a bad thing, it just doesn't justify the cost of what was installed, or the electricity it cost to run the fan.
More attic insulation will solve everything and give you real, easy to measure results in energy use. Sadly, it's really is that simple.
Spray foam has opened up all sorts of new and better ways to insulate a house. Closed cell has an amazing R value that also acts as a wind barrier. Open cell is just cheap junk and should never be used because it's more expensive then fiberglass with the same R value and it holds moisture. Homes will be rotting out from the inside because of open cell foam. If you want to spend the money on closed cell, and in a lot of applications, its money well spent, then it has been proven that spraying the outer shell of the home, which is the actual roof of the house is more energy efficient then the traditional methods. Closed cell eliminates venting, which means that another method must be used depending on what is used for the roof. If you change one thing, everything else has to be considered. You are now heating and cooling the attic space, so this also has to be considered when buying your HVAC system.
If you go with the whole house spray foam method, there are a lot of factors besides paying four times as much money for your insulation. If your energy bills are very high and you will be living there for decades, it makes sense. I plan on doing it for my addition where I will have a vaulted exposed beam ceiling, but not anywhere where I have flat ceilings.