The user automatically gets a profile page, in the form of http://example.com/author/user-name
When a user has no posts, most themes display the 404 template.
But it’s perfectly possible for a theme to customise the author.php
template to display more than just a list of posts by that user, even when the user doesn’t have any posts.
If that’s not enough, just use BuddyPress.