Unfortunately that's a hard question to answer truthfully.
If you have driven a manual, (I learned how on a truck...) its almost like riding a bike. You just know.. its a feel and a perception. If you haven't, I can see where it could be intimidating. Depending on gearing and power, (lower power vehicles oddly) you can be pretty busy. But it makes you more a part of the driving equation.
Advice. go rent a manual, get a buddy that drives stick, find an empty parking lot and have a ball.