Men's vs. Women's
The NCAA has only established rowing championships for women, which is the main difference between men's and women's teams. Also, women's rowing has had an increase in popularity over recent years (source), which means you can find a lot of schools that have NCAA women's rowing teams.
That doesn't mean that there aren't competitive men's teams. There are many rowing clubs and intramurals that participate in prestigious regattas around the country without direct NCAA involvement. Sorry, dudes, but women are killing it in the NCAA rowing game.
If you're looking for a scholarship, though, it's important to consider that rowing is an equivalency sport. NCAA Division-I women's teams can award only 20 scholarships per year even though they have an average roster of 67 athletes (source). Teams can distribute that money however they like, but it does mean that female athletes probably aren't looking at full rides.
If money is a concern and your parents aren't royalty, then you'll probably need to consider alternate funding sources. Noodling, maybe?
Otherwise, men's and women's rowing teams are both competitive, talented, and super buff.