I am the spray paint Queen!! I love spray paint because it's so easy to use and wow what a transformation it can make on any object. I have a box full of spray paint, all different colors and brands. I can't tell you how many pieces I have transformed with just a can of spray paint. Spray paint works well on glass, wood, plastic, pretty much anything you want to transform it can be done with a can of spray paint.
I do want to caution you no two brands of spray paints are the same. My favorite spray paint to use is Rust-Oleum ultra coverage it goes on smooth and even. I love the nozzle it has, makes for a great even spray.
I find with the Krylon the nozzle it tends to give a more sporadic spray
But really it just comes down to preface and what you like best. If I'm doing a project where I know I'm going to use two different paint colors I will use a cheaper generic brand for the bottom coat and will use my Rust-Oleum for the top coat. As you can see in the example below I used Walmart white for the bottom coat and Rust-Oleum for the top coat. If you know you are going to be layering colors there is no need to use the expensive paint for the whole project. I'm going to take a piece of sandpaper to this piece so I want the good stuff on top since the white is only going to be peeking through in spots no need to use the more expensive paint as your bottom layer.
You will want to do your spray painting on a day where the temp is above 70 degrees with no humidity. Your paint will crack if it is humid outside as you can see in this picture. Fortunately for me I was going for the shabby chic look so it worked for me, but if I wanted a smooth look I would not have achieved it.
If you are going to be doing a large project then you will want to get one of these puppies, trust me it will save your index finger. I honestly had a numb finger for weeks after spending the day spray painting wine bottles. You can/will thank me later, I promise :)
I want to encourage to find something in your house that you are not in love with anymore and give it a spray paint makeover. Be bold and unafraid to try a new color and see what happens. Worst case is you won't like it, but guess what you can always spray another color over it. Of course best case is you will love it and fall in love with your piece all over again. I am excited to see/hear how you do.