Sending personal emails to the first 1,000 customers is great, and switching to automated lead nurturing after that is great. Partly for scale - there are a hundred high-value things a CEO can do once a business gets going. But also because customers don't think it's appropriate to get a personal email once you grow to a certain size.
Anecdote: I've been heavily involved in our sales process at Zencoder since the beginning (as CEO), including writing personal emails to 500-1000 signups early on. (We've stopped that by now, but it was the right thing to do early on.) A few months ago, our sales director and I went to meet with a high-value prospect. At that point, their financial value wasn't huge (hundreds per month), but we knew they would grow, and that they'd be a good reference customer. So we pitched them and everything went well.
I ended up meeting with them a second time, and they asked me point-blank: "How is your business viable, if we're only paying you $X00/month?"
The subtext was this: "If we're only paying you $X00/month, and we get the CEO in for two in-person meetings, then you must be small, and we must be a critical customer for you to win." Customers should feel important, but never critical.
This came to a head when we sent them a final proposal. They asked for a price break and concessions, and said explicitly that because they were an important customer for us, we'd give them these things concessions. In reality, they were no more important than 20 other prospects we were working with. But because we brought our CEO into sales meetings on a small deal, they thought we were smaller than we were.
Responding to "it's a waste of my time to write the same email a thousand times" with "you should reply to each email personally" is moving the goalpost. The OP is about sending a first welcome email to every user that signs up, not about replying to an email sent for customer service or technical support.
I would never reply to a client using a canned response, I hate those with a passion. But the first email being sent, the client didn't send anything, doesn't know you or your writing style, didn't offer you any chance of customizing because it's just a "welcome to our service, thanks for signing up, I'm there if you need me" email. My point is, write it as if you would send it personally, but automate the actual sending.
Emailing the first 1000 users, fine. But doing it personally and manually, why? Aren't you going to end up using exactly the same text for all your users (either that or risk typos that make you look less professional, not more human)? Don't forget the risk of developing CTS while you could be doing much more constructive stuff.
I would say, have it automated but sent a couple of hours after signup, or have them sent in batches at a time where you would normally sit down and do it. I'm thinking that people either assume it's automated or they assume it's manual, one way or the other.