I haven't been doing nearly as much photography as I'd like lately - work and so on, along with vision issues that keep me from getting out with my smaller cameras as much as I'd like. So I thought that trying my hand at still lifes would be a nice change of pace and something I could work on at night.
Formats - 4x5, 6x6 and the 'D' word (starting with the latter for practice and mostly going to 4x5 color neg after that).
As your format gets bigger, remember that you need a smaller aperture to get an equivalent amount of DoF if you are filling the frame with 'the same' composition. That means that still-life on large format often needs a lot of light, or very long exposures. Still-life implies that long exposures are not a problem, but since that isn't always so (eg. reciprocity failure with colour film) you may find that what you are happy with in the way of lights when you use your digital isn't sufficient for your MF or LF gear.
But to look at that from the glass-half-full perspective, that means that you can use cheaper lights while you are learning and finding out what you really want to buy later.
Natural light isn't really an option, I live with the worst lighting known to man (and will be working at night much of the time). At home the windows are small and badly placed, my warehouse/office space has very plain, broad light from the opaque 'sunroof' panels.
Actually, the very broad flat lighting from your translucent roof panels sounds like it might be quite useful. A lot of still-life benefits from that sort of light. It won't be the light you'll want to use for every composition, not by a long way, but you should give it a try out as one more sort of light in your 'kit'.
Hot lights seem like the easiest and cheapest for learning - but using heat in either a confined space or an un-air conditioned Texas warehouse has me wary.
Fluorescent lights are a nice compromise between unchanging light and heat (and cost) - but as I understand it they may not provide enough contrast to shape light. Good for products and small things, though.
And finally, flash - a one or two head kit, umbrellas, soft-boxes, homemade reflectors, sync cords, whatever trigger will work with my SLR. Not sure about the quality of affordable brands, would probably trawl Craigslist for something used and local. No WYSIWYG, the learning curve seems a little steeper.
The more I look at it, the more I lean toward the latter. Is there anything I'm missing or words of advice that might be offered?
I do quite a lot of still-life, both product and conceptual commercial stuff and more 'fine-art' things. I use a variety of formats, most often 6x9 (on a monorail) but also LF up to 10x8. For this I use everything you mention except fluorescent.
The fine-art type work is more often lit with natural light than artificial, while the commercial is most often lit with flash or hot-lights - but this is not a hard & fast rule. I don't have much experience of fluorescent.
Hot-lights do come closer to being WYSISWYG, but as has already been noted, there is really no such thing in photography. They are particularly good for complex set-ups: lots of small quartz lights cost a lot less than lots of flash-heads.
Hot-lights come in a range of special types: fresnels and focusing spots, broads and scoops, cycloramas, soft-lights. This means you can get lights that are really tailored to do a particular job well. There are also more general purpose lights - redheads and blondes, for example - that can function sort-of-like fresnels or sort-of-like scoops.
My kit has several small and one large general purpose light, several broads, a couple of cyclorama lights, and never enough fresnels.
The heat is a real issue. I've never felt comfortable with the idea of softboxes on hot-lights either, so softening, for me, relies on brollies, bouncing lights off flats, and sheets of diffusion material.
Flash's great advantages are lower temperature and high light output. The latter is very helpful with LF and with close work where there's a lot of bellows extension. The former is important for your comfort, but also remember that a lot of still-life subjects can be quite temperature sensitive: a vase of flowers will wilt very fast under hot-lights, and even apples in a bowl of fruit will get wrinkly soon.
Flash-heads tends not to come in such a range of purpose made designs as hot-lights (unless you are paying a lot of money). This means that one design must do more different jobs, by having a lot of different reflectors and other light modifiers. Flash can be made very soft easily, and for a bit more money can do a very good job in the focusing spot role. Tends not to work so well in the cyclorama light role though, and if you want flash to work like a fresnel you need to spend a lot of money.
Daylight can be modified and controlled a lot too, with diffusion, reflectors and cutters.
I think I rambled rather, but hope that explains some of why I use both flash and hot-lights rather than seeing it as an 'either / or' decision. If I had to choose one to start with I'd probably start with hot-lights, unless I planned to concentrate on flowers, food, or similar subjects.
If you budget as much on light modifiers as you do on lights you'll end up much better prepared than if you buy more lights but have fewer ways to control them. I would really stress that point.
In addition to Roger's book, I strongly recommend "Light, Science and Magic" by Hunter and Fuqua.
Peter