As far as Aerith comforting Tifa at the end goes, I think Aerith couldn't do that as it might mess up her act in front of Cloud. So I think it's fine.
My theory is that Rebirth Aerith figured out her feelings on Cloud during the gondola date, and Dream Date Aerith needed to also double check...
Nah, Tifa totally is in love with Cloud from the start. She's an absolute sweetheart, but she doesn't choose to watch over a mind wrecked Cloud because he's just a friend
We just don't know Cloud's feelings til the end (although the player can flirt all they want with her up til the date)
Also hello all! I'm sort of new? I have been lurking for days and pretty sure I had a different account here many moons ago during the AC Era lol. What that was idk anymore, but I think it's awesome this forum and club still exists