For fish, as long as it is fresh it should be safe to eat. Yes you can make sushi at home. Usually fish that is used for sushi is very good quality fish. If you go to a good quality supermarket like whole foods, or something similar you can ask the person at the fish counter which fish would be good for making sushi.
Sushi is not the easiest thing to make. I know it sounds very simple. It is just rice, seaweed, fish, and some vegetables or some variation of those ingrdients. The hard part is getting the rice right. I mean people in japan can spend 10 years learning how to cook rice for sushi. I am not saying you need to spend 10 years making sushi rice, before you can make homemade sushi, but it is not something you will learn the first time. I am not very good at making sushi rice, so I just decide to go out for sushi or buy already made sushi from whole foods.
As for beef carpaccio and other raw forms of beef, it is safe to eat at home. When I have had it at home, we always use a meat grinder and grind the beef ourself. It is just a meat grinding attachment to the electric mixer. That way you know you are getting good quality meat. If you do not have a meat grinder or do not want to take the time to grind it yourself, ask your butcher. If it is a good butcher they should grind the meat for you if you ask.
With all that said, there is always a risk when eating raw food. No matter if it is at a restaraunt or at home. Just stick to using fresh and good quality products and you should be safe.