I agree. I can understand why some people complain about the closed nature of iOS and the App Store but in the end Apple just wants to make sure the end user gets the best experience with their iPad hence the curated App Store and closed iOS platform. If the App Store was open and apps were not reviewed before being on the App Store, you can see things could be much messier for apps that don't work properly and some apps, like what is technically possible on the Google Android Marketplace; apps that do stuff that they shouldn't be doing. I can see where people become overwhelmed and annoyed at Apple's restrictions - and certainly, certain decisions by Apple have been bad ones and they've corrected it when they realise they were in the wrong - like an app that defamed political figures; Apple employees have to stick by the rules and had to reject the app - but Apple later realised they did not cover that area which is fine and subsequently modified their terms for exception of political figures. Same is with an app that did WiFi syncing; I don't think Apple wants a developer to control WiFi syncing when its the concern of data and the syncing to the iTunes software; so this is why Apple probably rejected the app when some developer submitted it for approval. Jobs has stated at an interview at AllThingsD that "we're working on it" (referring to WiFi syncing) so it's probably going to come in the forseeable future.
In regards to Flash I have to agree with what you said about accessing the Honda website as an example and finding out that the iPad can't view the important Flash content on that website. But again, I can understand why Apple doesn't have it on it's platform (and I'm not going to repeat and go into "why" - we all know Apple's case on the exclusion of Flash from it's platform). Sure, there can be some viable options to get Flash on it's platform; but I dont think Jobs would allow a half baked solution; Apple perfects everything down to the simplest thing and if Flash causes complications to the user experience, we know fair well Apple ain't going to have it on iOS. The exclusion of Flash is a limitation, sure, but you can say the availability of video content in native HTML5 format on many websites has certainly improved recently since the iPad can and is used to surf the web like on a computer. But like with the Honda website, it's certainly an annoying limitation of the iPad, though. You can say it's a compromise and Apple probably realises this.
Someone has probably got a counter-argument to all I have said above and may think I'm a "fanboy" that believes whatever Apple says; but honestly, don't take it all too seriously. What Apple is doing works for most people that use their iPad (as the quoted post a user says above) and a lot of people are satisfied with their iPad.
This isn't a counter argument, I just want to point out that there are a lot of people who use Android who wish Google would do more overseeing of the Market itself. There are tons of totally junk apps in there and it can be tricky to weed out the good stuff from the bad.