I pretty much always make it with fresh fettuccine; it really soaks up any extra liquid and makes for a truly lovely dish. On one occasion I made it with spaghetti, and it was still pretty good

As fuzzy says, pasta should never be mushy, regardless of size, but I do prefer creamy thick sauces with more substantial pasta.