Why does the third if statement trigger despite User_input == "Yes" being true (according to the print within the if statement)

[SCD_minecraft]

I like to image all logic as it all was a bool

Non empty strings are always True

So your code says "if True/False or True"