I disagree that sand vs bare-bottom is aesthetics only. There are consequences of the decision either way, and there are many other factors that influence the success of that decision such as flow, aquascaping, stocking choices, husbandry, etc.
We choose to go with shallow sand bed for the looks of it, to enable us to keep the kinds of animals we like (e.g., leopard wrasses), and to promote stable, natural processes. The shallow sand bed is absolutely sustainable indefinitely without causing problems, but requires upkeep. For example, we find that stocking benthic livestock such as sea cucumbers, fighting conchs, nassarius snails, brittle stars, etc., are desirable and very helpful with keeping the SSB viable. We also frequently stir and vacuum the SSB to keep the detritus from accumulating. Having a well designed flow pattern in your tank is necessary (true if you go bare-bottom or otherwise) to help keep detritus in the water column and into your filtration systems.
As far as the lighting choices, that is a whole other can of worms.... As Dave mentioned, do your homework. Read all you can about the experiences of others and make informed decisions. The advice from your LFS may not be bad, but remember it is just one data point. Online forums provide a wealth of additional info that can help educate and enlighten before you spend any of your hard-earned cash.