My personal preference has been for any Honda two-wheeled vehicle - I've owned 6 motorcycles & 1 scooter. I can say with confidence that you should definitely go for a motorcycle. If you are confident that you will never / rarely go onto the highway, you can get something with a 250cc engine that will be very good on gas, but will still have the ability to accelerate quickly to get out of traffic trouble at city street speeds. Scooters just don't have enough power to be safe in my opinion. Besides, it is much easier to put some kind of bag(s) on a motorcycle so that you can carry things back & forth from work, or even make relatively small trips to the grocery store.
If all my logic fails to persuade ... motorcycles are just damn fun! I don't think you'll be unhappy if you get one.