Manual processing of requests is probably fine for many launching apps (unless there is the possibility of automated content creation on the part of your users), which also lets you be really careful with complying with applicable laws while (crucially) maintaining the rights of your users.
But, yes, if you're in the US and want to maintain safe harbor protections, you will have to handle any takedown requests you receive.
If you don't register an agent, you are not protected by the DMCA safe harbor provisions.
Once you've got a registered agent, you'll need to internally create a DMCA notification procedure that you'll follow once you receive them. The system is very simple and extremely fair to ISPs/sites. Talk to a lawyer, but most don't know the DMCA well and you can find this stuff out on your own generally.
It's far more likely that no one will even notice your site, rather than spammers start piling on. Implement basic logging & monitoring and you'll be fine. It may suck when/if it comes, but scaling & abuse defense is usually a good problem to have. Worst case, you've got a completely idle server!
Should we only bother with it after it becomes a problem (hopefully by then we'll have enough revenue to afford this)? Or is it too risky to launch without such system and get brought down ourselves?