On a tripod, with "added" light, I guess "almost" any lens could do if you have the room to move around, for that kind of shots. Distortion can be corrected in PP (i.e., LR3 or DxO fix that automatically for many lenses now...).
So re-reading the original post, I guess the decisive factor is more about getting a good, standard lens for everyday usage than for 'product shots'... So decicing btw DA35 2.8 Ltd, DA 35 2.4 or DA40 2.8 is a budget question and usage question (cheap 35 Vs very small Vs macro swiss army knife...).
But limited budget + everyday lens = DA 35 F2.4, seems to me
Or you may also choose to go for older, manual lenses...