I would stick to a white. In my opinion, they will taste better at 6 months than a red. Not to say that you couldn't do a red. I just think the results at 6 months would be better with a white. I usually prefer the kits that are a little above your price range. I guarantee you would have fantastic results with something like this:
Both of these kits will produce something equivalent to a $25 -$40 bottle of wine. The more juice that comes with the kit means less water used to dilute it down. Also, wine kits are heavy and expensive to ship. While Northern Brewer is an excellent company, you could probably find the same kit at a local shop for less money and not pay shipping.
If you are dead set on your budget, you would also have good results with one of these:
I selected the Riesling and Gewurztraminer because I think both of those are fantastic as a sweeter wine.
Good luck! Keep us posted on what you decide to do and the results.