"All work and no play makes Jack a dull boy." You and the guy your friend dated are probably just incredibly boring people. That's why women aren't interested.
This is half of it. You got no game. That doesn't mean be dishonest. That means be honest, but work on appealing to potential mates. (sex appeal == "fun" and other stuff) For some appealing to a prospective mate is a task, for others a pleasure. Get to work on it.
The other half is biology. Stodgy work,work,work types isn't appealing to most women. If you are generating real wealth in your work,work,work mode then the money will compensate in a couple of years. Of course, that means they'll probably cheat on you too because you are the money person, not the "sex appeal" person.