Ram air will not benefit you like you think, especially an NA. Unless you were traveling well past 100 on a daily basis. If you're looking for horsepower, it'* not the way to go.

Cooling is always a good idea. Just having an open hole(*) in the hood will allow air to cool the engine. But having hood vents will further help cool it down as hot air will exit the engine bay.

With our engines, you want to let the heat OUT the hood. Not pull it in there. The air is already pre-heated after passing through the radiator. Install VENTS. Not scoops.

Will is right the air going in to your engine is more than enough, but it gets pre-heated going in to the engine, then it stays there getting hotter. youll gain more getting it out so that more cooler air can go in. But you can still fab something cool looking that might not be 100% ment for performance, nothing wrong with that.
Dont let people tell you "dont doit". If you have the time, space, & patience... go for it.
fiberglass is not that hard to work with. I did my own hood scoop & it wasnt that expensive. Look around & youll find tons of info for fiberglassing, or just find a shop that can fab one for you.
Best advice I could give you: remember your driving a Pontiac, & try to stick to your roots. At the end it looks best.