It's generally better to handle 404 pages with a custom "profile deleted" page, rather than leaving them as a 404 error. This provides a better user experience and signals to search engines that the content is intentionally removed, rather than just being unavailable. Additionally, it may prevent potential drop in rankings or negative impact on crawlability due to the accumulation of 404 errors.