If it's just the middle part of the hood your doing a rattle can may be ok. Might be worth a can to test drive it on something to see if you like it, and can get it to lay down uniform with no lines or streaks.

The Sherwin Williams stuff I was not able to find locally as I wanted to buy a small can to see what it looks like years ago. The Sherwin Williams stores here just do house paint.

The white PPG 1999 paint texture additive appears to be a super fine sand or talcum powder like product. Might be able to get something like that from another source?