Real algebraic geometry comes with its own set of methods. While keeping in mind the complex picture is sometimes useful (e.g. for any real algebraic variety X, the Smith-Thom inequality asserts that $b(X(\mathbb{R})) \leq b(X(\mathbb{C}))$, where $b(\cdot)$ denotes the sum of the topological Betti numbers with mod 2 coefficients), most of the technique used are either built from scratch or borrow from other areas, such as singularity theory or model theory.
The literature is a lot smaller for RAG than for traditional AG; the basic reference is the book by Bochnak, Coste and Roy (preferably the English-language edition which is more recent by more than 10 years, and has been greatly expanded). The book covers in particular the real spectrum, the transfer principle (which makes non-standard methods really easy), stratifications and Nash manifolds, among other topics. Michel Coste also has An Introduction to Semialgebraic Geometry available on his webpage a very short treatment of some basic results, enough to give you a first impression.
Other interesting books tend to be shorter and more focused than BCR, dealing with a specific aspect; e.g. Prestel's Positive polynomials. (dealing mostly with results such as Schmudgen's theorem), and Andradas-Brocker-Ruiz Constructible sets in real geometry (dealing mostly with the minimum number of inequalities required to define basic sets). The book by Benedetti and Risler is very interesting and concrete; I found some passages very useful and some results are hard to find in other books (the sections on additive complexity of polynomials are very thorough), but it is a bit scatterbrained for my taste.
As the name indicates, the book by Basu Pollack and Roy is entirely focused on the algorithmic aspects. It's a very good book, and you may still pick up some of the theory in there, but it does not sound like what you are after right now.
As for o-minimality, there again, Michel Coste's webpage contains an introduction that nicely complements van den Dries's book. I would hesitate to bundle o-minimality with real algebraic geometry. In some respects, the two domains are undoubtedly close cousins, and o-minimality can be seen as a wide-ranging generalization of real algebraic structures; on the other hand, each disciplines has also its own aspects and problems that do not translate all that well into the other.
I'm being verbose as usual. Still, I hope it helps.
I agree with Donu Arapura's complaint about the artificial distinction between modern and classical algebraic geometry. The only distinction to me seems to be chronological: modern work was done recently, while classical work was done some time ago. However, the questions being studied are (by and large) the same.
As I commented in another post, two of the most important recent results in algebraic geometry are the deformation invariance of plurigenera for varieties of general type, proved by Siu, and the finite generation of the canoncial ring for varieties of general type, proved by Birkar, Cascini, Hacon, and McKernan, and independently by Siu. Both these results would be of just as much interest to the Italians, or to Zariski, as they are to us today. Indeed, they lie squarely on the same axis of research that the Italians, and Zariski, were interested in, namely, the detailed understanding of the birational geometry of varieties.
Furthermore, to understand these results, I don't think that you will particularly need to learn the contents of Eisenbud's book (although by all means do learn them if you enjoy it);
rather, you will need to learn geometry! And by geometry, I don't mean the abstract foundations of sheaves and schemes (although these may play a role), I mean specific geometric constructions (blowing up, deformation theory, linear systems, harmonic representatives of cohomology classes -- i.e. Hodge theory, ... ). To understand Siu's work you will also need to learn the analytic approach to algebraic geometry which is introduced in Griffiths and Harris.
In summary, if you enjoy commutative algebra, by all means learn it, and be confident that it supplies one road into algebraic geometry; but if you are interested in algebraic geometry, it is by no means required that you be an expert in commutative algebra.
The central questions of algebraic geometry are much as they have always been (birational geometry, problems of moduli, deformation theory, ...), they are problems of geometry, not algebra, and there are many available avenues to approach them: algebra, analysis, topology (as in Hirzebruch's book), combinatorics (which plays a big role in some investigations of Gromov--Witten theory, or flag varieties and the Schubert calculus, or ... ), and who knows what others.
Best Answer
If you have already learned classical algebraic geometry and are planning to study how it's been studied through stacks, one of the best places to learn from is the Stacks Project. While I understand that it is not a textbook, it is a collaborative mega-project that uses stacks to study algebraic geometry. You may also like to read Toen's course notes, Demazure's book, and Anton's notes.
Just one note - you may not be very well motivated to study derived categories and stacks without first learning classical algebraic geometry, eg., Hartshorne. While they are used in research in algebraic geometry, they might seem like very complex things that cannot be used correctly. (Of course, one can go into a whole discussion about why this is usually discouraged, but this is not the scope of the question.)