Trending @Accenture; Booked a seat but it is on the waiting list and got cancelled automatically. Does that count as wfo?

No. Swipe in will only be considered as attendance in office. WL in seat booking would still be safe for you because you tried for wfo atleast.

As far as I know, it'll be considered as an attendance it seems , need to double check with others .....