You are certainly not the only person with an irrational aversion to buses, but I think you are overestimating how many others have that same prejudice. For example, the bus+train combo is so popular that during busy periods GO needs to run three double-decker buses back-to-back just to handle the number of people who want to use it to get to Kitchener.
Most people do not completely discount certain modes of public transit, rather they make choices based on the performance of public transit (speed, frequency, reliability, comfort, etc), regardless of what mode is used to accomplish that.
Rail
can be faster than buses, but that is not necessarily the case. Route 30A, which runs non-stop from Bramalea to Kitchener, is considerably faster than the train. For example, you can get off the Kitchener train at Bramalea at 10:09, wait five minutes for bus route 30A (which holds for the train connection), and get to Kitchener earlier than the train you were just on.
View attachment 555994
The key difference here is that all Kitchener Line trains make every single stop between Bramalea and Kitchener (even the express trains!) while the bus runs non-stop using a tollway to avoid congestion in the GTA.
The counter-peak situation is currently very bad indeed and needs to be improved. Due to the peak-period traffic congestion, that's one time of day when a direct train has a particularly large advantage over a bus.
As you've described here, the biggest issue is in fact not whether the service is operated by a bus or train, nor how frequent it is, but rather how long the travel time is. Even if we had a direct train every 15 minutes, it would still be very uncompetitive for your trip. If it takes 40 min for you to get to Union, 1h50 on the train and 15 min to get to work from Kitchener GO, then you're still looking at 2h45, which is double your quoted driving time, regardless of how frequent it is, and regardless of the fact that you don't need to take a bus.
This is my point. It is not enough to just ask for a frequent direct train service to Kitchener instead of the bus+train connection. We need to be pushing Metrolinx to operate a faster and more reliable direct train service, because the travel time on its own is already enough to dissuade many riders. That means ensuring that trains from Kitchener and Guelph make as few stops as possible, with separate local trains serving demand between Brampton and Toronto.
A travel time of 1h or less would be an average speed of 100+ km/h, which is far outside of the territory of regional rail. Even the fastest regional trains in the world only average about 80 km/h. Above that is really the territory of intercity rail (stop spacing 25+ km). So Via Rail in our case. The downside of intercity rail is that it tends to be focused on much longer-distance trips (e.g. to London, Sarnia, Windsor) so they can get away with a lower degree of ticket flexibility.
See for example, the case of London UK to Oxford: although there are fast and frequent trains, they have variable ticket prices so if you just show up at the station you end up spending a fortune. Which severely undermines the flexibility of those services for regional travel.
View attachment 555996
View attachment 555998