I went from Auto to Manual... some days I love Manual, some days I want the clutch pedal to go away.
City driving isn't all too bad, so long as you still use the stock clutch and the traffic isn't crawling/rubber necking.
I would suggest picking up a really cheap manual car to try out and learn, if you like it, then buy the real car, if you don't like it, you're not stuck with an expensive mistake.