>>65820141TL;DR: No, I don't think I can be friends with women I want to fuck.
Chuuba example: Previous kamioshi would sometimes DM me. Talking to her made me so fucking nervous, I couldn't type straight. I am incapable of having a casual, direct conversation with her despite all the interests we share. Several thousand chat messages, and it did nothing to prepare me for those moments. In person, my nervousness would probably balance out after a few minutes, it does with most attractive people I meet, but I know for certain that I'd wanna fuck her on every piece of furniture in the room, and I don't think it would be any different with my eien oshi.
RL example: I have a female coworker that I maintain a relationship like you describe it with, sans the late night chatting. We do chat at odd times, but it's not the kind of deep or engaging conversation I assume you had in mind, more like off the cuff have you seen this, check out my BG3 character, here's a cute dog picture btw I was raped yesterday kinda deal. We go out to watch movies, grab drinks, usually chat over coffee, that kinda deal. Anyway, this friendship only exists because I initially did want to fuck her, so >0 romantic interest, 0 sexual tension doesn't apply, it's just that I lost interest because she's an unapologetic harlot but we had already become friends and she hasn't done anything to me that'd warrant ending our friendship.
I'm a cute seal btw :3