I bought my 10g there with stand, and it is an All Glass brand aquarium. I had no problems at all with it, other than the Aquatek filter that comes with it is so cheap that the filter media won't stay in place because the flimsy plastic housing of the filter bowed and is now too wide to hold it. Other than that it was a great deal-heater, filter, hood. I replaced the flourescent hood with the incandescent hood and used the same compact flourescent bulbs mentioned earlier because it's like night and day the brightness level. The CF bulbs are very bright compared to the tube.
As far as bowfronts, they only sell up to a 5g acrylic bowfront and a 5g hex. I bought a 2.5g bowfront for my sick tank, and it come with a nice little incandescent hood and bulb. You don't need a heater because the bulb heats that little bit of water.
Overall, I think that everything Wal-Mart sells is fine, but stay away from the crappy Aquatek filters. They don't have the biowheel, and their housings are flimsy crap! Wal-Mart sells the Tetra Whisper right next to them for about $4 more, so spend the extra money.