I think it depends on what you're shooting as to how helpful it is.
Having swapped from a Bridge camera (being able to view on screen) to a DSLR without live view, I've missed it on a couple of occassions.
Mostly these have been when shooting (as suggested) macro shots, or landscape shots. There have been a few occassions when the camera has been in a position that has made it tricky to look into the view finder (like on the ground), and in this case, live view would have been useful.
I do also take some shots whilst holding the camera a hip or chest height, in order to get more candid shots of people (if they see you bring a camera to your eye they freeze up or hide), so live view might also be useful here, but it's not essential.
I have a Sony Alpha 100 already, so I would be looking at one of those models if I was upgrading, but having tried them recently in a shop (to test lenses) I wasn't fussed with the flip out screen, in fact I'd worry about it's durability, and actually I would want the slightly bigger a330 if anything because the a230 felt too small and flimsy.