Beginners Riders Course is the way to go. If nothing else, it's cheaper than cruching something you bought and then trying to sell it at a loss. It can also save a lot of tension (at best) between married people.
I've known 2 women who passed the course, got a bike, and still couldn't stand getting out in traffic. A couple of others are racing around on Ducati's and BMW's. You just never know until it happens.
Vespa makes a couple of different sizes, as does Piaggio. Personally, I like the looks of that Suzuki TU250X (a LOT). Used Honda 350 /360's are good. Also the CM400T is a really good size -and cheap. If you go the Big Scooter route (I forgot the name of the big seller), I've often heard the 450 is better than the 650 because of the drive train, which is different.
There is always the tank bag or back-pack route, too.