I played EVE for many years, starting in 2003; deleted many characters that I spent years on, and created new ones to have several fresh starts. It's a game you have to play with friends to really get into, and it can suck up a lot of hours of your life. However, for as much praise as EVE gets for being a sandbox and a completely ruthless and unique pvp experience, I feel it always stales for me even when I have a lot to do. I used to take long breaks from it because of that.
EVE is a game that is designed for hardcore players. By that I mean people who are good at the game, but also who will play it nonstop. You have to PVP. It doesn't take much skill in the traditional, react and move about kind of way, but its all about tactics and getting the edge out of other players. An unfair fight that you win in EVE is a desired victory.
It's also spredsheets galore, and very newb unfriendly. EVE is all about stats, statistics and graphs. Honestly, playing EVE just makes me want to play Elite nowadays. I have 3 years left of sub time in my account. I pop in, do a few things and I'm flying in elite 15 minutes later. It's also a very old game, 13-14 years old; because of that, there is an innevitable hardheadedness from both the community and the developers to accept and embrace change, or new ways of doing things. The community is super niche, much more so than Elite.
Player Generated Content™ is as awesome as it is overrated. You're probably used to reading the cherrypicked stories that get published in gaming news outlet that make EVE look like an epic science fiction Ode, but when you are actually in-game living it is less... epic. Turns out those reportings exclude all the t-bagging, player drama and insults (both in English and Russian) hurled during the historic clashes. It's also at a point that I find it way more entertaining to read about than to play and experience for myself.
Also, EVE is very restrictive, gameplay wise. We get a lot of complaints about how shallow ED is, but it's always a headscratcher for me that then EVE is cited as the prime example of gameplay freedom. There's no first person view, no cockpitview, a joke of space legs, no planetary landings of any kind, very outdated navigational systems for your ships, and everything you do that is not messing around is a timesink. Want to fly a ship? wait a few months. Don't matter if you have the money. Want to equip something to said ship? Wait a few months more. Rinse and repeat. Sure you can inject skills if you're rich but still... all feels very time framed and restrictive for you as a player.
Personally I would try it if you are curious, specially with semi-free to play going on, but I'd keep my expectations in check, specially if you've heard the exaggerated praise it gets for being more "sandbox" than ED.