no you didnt waste your money buying a standard bulb but the best ones are specifically for horticulture use there is atleast a couple of different brands probably more and are considerably more expensive, like the hortilux eye just to name one.
its not always worth the expense to use one of the better bulbs if you are just growing for your own personal use, would suggest just using a standard bulb and have atleast a couple on hand and remember to change them as maintence every 8- 12 months as their lumen output does degrade with use regardless of which bulb you decide to use.