The game seems pretty impressive during your first 10-20 hours. You pick one of three planets to wake up on. You wake up in a city (that lags at like 20 FPS) and spend an hour or two walking around marveling at everything, maybe spend half an hour buying different clothes or armor pieces and admiring your self. Then you go to the spaceport and marvel at your spaceship, tour the inside, look inside the bathrooms and cabinets. And then you take off and spend an hour flying around the planet (the forests and mountains of Microtech, the city planet of ArcCorp... or if you picked the dull desert of Hurston, well, there ain't much to see). Then you probably fly into space and go touring the other planets and moons and space stations. Spend hours touring through other people's ships. Then you maybe do some missions where you blow up NPC pirates or clear out bunkers with dank FPS combat. You will quickly learn that FPS combat is borked and that you should avoid it because of the netcode, where you will be killed by some NPC bandit you didn't know about and then as your body falls to floor, the camera zooms out to show that some bandit shot you through a wall or something.
After a few hours of blowing satelites or small bandits for a little bit of cash, you will want to look to upgrade your ship... and then see the huge price tags on buying new ships ingame. You will find out that the fastest way to make money in Star Citizen is to farm a mission called "Two in the Head", where you and another player have to kill two different targets in two different locations within 90 seconds of each other. You make like 200k-300k credits per hour doing this. So if you want like a 3 million credit ship, you'll be spending several hours farming to save up the money to do it, doing the same thing over and over and over. And at that point people start getting demoralized by the grind and start looking for other, more fun things they can do immediately with the ship they have.
They soon start getting into PvP. You might try becoming a bounty hunter who hunts criminals, but you will quickly realize that this game is terrible at pitting PvPers against other PvPers together ingame. You have to find some obscure discord community and attend one of their scheduled events to find consensual PvP. As a bounty hunter, you will spend 90% of your time doing nothing while your ship is quantum travelling towards your bounty target... only for your bounty target to either be sitting in an armistice zone (which means you can't get them), or quantum travelling to some other location, or they log out, so you almost never get to actually fight criminal players.
Left with no other option to find entertainment, you turn to becoming the criminal player who preys upon the weak. You might go around popular mining spots looking for miners, and then wait for them to start packing up to leave before running in to kill them and hijack their payload full of stuff, or using EMP guns to shut down their ship (and hope it doesn't explode when it crashes into the surface). Maybe you rack up a bounty, hoping that player bounty hunters come to you. Unfortunately, they never do and only boring NPC police show up.
Eventually you somehow wind up getting killed while you are a criminal (usually in FPS combat). This time, rather than respawning at the last city or station you visit, you instead wake up in prison. This is the most interesting thing to have happened to you over the past few dozen hours of play. You see that you have a real world timer ticking down your sentence (like 2 to 24 real life hours in prison). You are told that you can speed up your sentence by working in the prison's mines, so you do that for an hour. If this is your first time mining, this is when you find out that mining is... theoretically interesting, but in practice is tediously dull. After filling up your backpack, you turn in your ore... and see that your sentence has only been reduced by like 2 hours. Demoralized, you are tempted to just log off and stop playing for the day, and relog the next day when your sentence has expired.
... Or, if you explore the prison area (or have prior knowledge), you might find a secret passageway that leads to an escape tunnel. You then spend the next hour or two progressing through the escape route, which is sort of a jumping puzzle (in a game with terrible netcode and physics so the controls and responsiveness feels incredibly janky). This is actually pretty interesting. After dying a few times, you eventually memorize the jumps down and are able to complete the route in like 5-10 minutes. You eventually make it to the surface and hijack a rover and drive away from the settlement... only to realize that you have no way off the planet. So you have to call in public chat hoping that someone comes to pick you up (and doesn't just kill you to send you back to jail). If you don't get killed and someone does come to pick you up, then the two of your fly to Security Point Kareah to try to get your crime status wiped. You still have a bounty so theoretically this is a dangerous and exciting journey where people will be after you left and right. Sometimes that does happen and it's awesome. Most of the time, though, no one comes and you just reset your crime stat and you're now a free man.
At this point, you've pretty much seen everything SC has to offer.
- - - Updated - - -
I've spent several hundred hours playing Star Citizen. I think SC is worth checking out over one of those free weekends, or dropping $45 on to check out. Lot of fun for a few hours. However, once you've done everything, it becomes pretty stale. The game has been pretty much been the same for the past 3-4 years, with each patch only bringing on maybe some new ship or city I check out for like half an hour before logging off. You'll only really have fun in the long term if you find some other players to play with.